SQL
Public
Find Duplicate Emails
Find duplicate email addresses in a users table.
#sql
#duplicates
#email
#data-cleanup
SQL
SELECT email, COUNT(*) AS duplicate_count
FROM users
GROUP BY email
HAVING COUNT(*) > 1
ORDER BY duplicate_count DESC;Notes
HAVING filters grouped results. WHERE filters rows before grouping.
