Wednesday, August 31, 2011

Finding Duplicates with SQL

Select email, count(email) as NUMOCCURRENCES
from users
GROUP BY email
HAVING(COUNT(email)>1)

No comments: