Lists all Duplicate email hashes for http://meta.stackoverflow.com/q/70207
Q&A about the site for science fiction and fantasy enthusiasts
-- Duplicate Email Finder -- Lists all Duplicate email hashes for http://meta.stackoverflow.com/q/70207 SELECT EmailHash, DisplayName, COUNT(EmailHash) AS NumOccurrences FROM Users GROUP BY EmailHash, DisplayName HAVING ( COUNT(EmailHash) > 1 ) ORDER BY NumOccurrences desc