Duplicate Email Finder

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

Stack Overflow

Q&A for programmers

-- Duplicate Name Finder
-- Lists all Duplicate account names for http://meta.stackoverflow.com/q/70207

SELECT EmailHash,
 COUNT(EmailHash) AS NumOccurrences
FROM Users
GROUP BY EmailHash
HAVING ( COUNT(EmailHash) > 1 )
ORDER BY NumOccurrences desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached