Finding duplicate values in a SQL table

⬅️ SQL 🔗 Stack Overflow

It’s easy to find duplicates with one field:

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

How do you get duplicates with the same email and name?

SELECT
    name, email, COUNT(*)
FROM
    users
GROUP BY
    name, email
HAVING 
    COUNT(*) > 1