sqlite> 
CREATE TABLE "table"(ID,Tag1,Tag2);
-- Populate table, then"
select * from "table";
ID          Tag1        Tag2      
----------  ----------  ----------
1           science     math      
2           science     algebra   
3           history     math      
4           science     math      

sqlite>
   SELECT t.id,t.tag1,t.tag2  from "table" t 
        inner join ( SELECT  Tag1, Tag2, COUNT(*) c
                     FROM 'table' 
                     GROUP BY Tag1, Tag2 
                     HAVING c > 1) x
        on t.tag1=x.tag1  and t.tag2=x.tag2;
ID          Tag1        Tag2      
----------  ----------  ----------
1           science     math      
4           science     math