We have “DISTINCT” to select unique entries, but what about duplicates? Here’s how:

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