Search

Sunday, October 26, 2008

Finding Duplicates with sql

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

No comments: