find duplicates in sqlite

My table has 3 columns: col1 col2 col3 I want to detect all columns with duplicates in col1 + col2. SELECT *, rowid, COUNT(*) c FROM “table” GROUP BY col1, col2 HAVING c > 1 This query will give me all row ids with equal values in col1 and col2.