Find duplicate rows

SQL query to find rows with duplicate values in a column.

SQL5 linesUpdated Jul 17, 2026

SQL

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