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 professional and enthusiast programmers

-- Duplicate Email Finder
-- Lists all Duplicate email hashes for http://meta.stackoverflow.com/q/70207

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results