I find it. It goes here. You like it. The end.

Finding duplicates in SQL

via http://www.petefreitag.com/item/169.cfm SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )