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 )
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 )
Tanya Nam 