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,Id,
 COUNT(EmailHash) AS NumOccurrences
FROM Users
GROUP BY EmailHash,Id
HAVING ((COUNT(EmailHash) > 1) AND (Id = -1))
ORDER BY NumOccurrences desc

Enter Parameters

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