SQL: Find duplicates

A short, tested SQL example for find duplicates. Copy it and adjust the names and paths for your project.

SQL

SELECT email, COUNT(*) AS n
FROM users
GROUP BY email
HAVING COUNT(*) > 1;

Find it in Zest

Search for “sql find duplicates” in Zest and this example appears above the results, with other matches to choose from. Searches stay private.