Finding Duplicates with SQL

Quite a handy query for finding duplicates in a table (setting ’email’ to the field you’re checking for duplicates and ‘users’ to the table this field is in of course)

SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )

via Finding Duplicates with SQL.