0

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited jun 14 12

created nov 15 10 anonymous