Posted onFebruary 9, 2011 by Josephine finding duplicates with sql SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING ( COUNT(email) > 1 )
