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 Email Finder
-- Lists all Duplicate email hashes for http://meta.stackoverflow.com/q/70207

SELECT EmailHash, DisplayName,
 COUNT(EmailHash) AS NumOccurrences
FROM Users
WHERE DisplayName = 'lexdean'
GROUP BY EmailHash, DisplayName
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