Find duplicate records

📝 SQL

bowenjonathan73 · Level 2 · 27/05/2026

This SQL snippet helps you find duplicate records by grouping on key columns and filtering for counts greater than one.

SQL

SELECT keycolumn1, keycolumn2, COUNT() as duplicatecount
FROM tablename
GROUP BY keycolumn1, keycolumn2
HAVING COUNT() > 1;

-1

diana49945 29/05/2026

I've used this exact pattern to clean up a messy CRM import where customers were duplicated by email. Saved hours of manual matching.