COUNT(email) AS NumOccurrences
GROUP BY emailHAVING ( COUNT(email) > 1 )
You could also use this technique to find rows that occur exactly once:
GROUP BY email
HAVING ( COUNT(email) = 1 )
I am the owner of Stagich Software Consulting. Stagich Software Consulting specializes in developing Microsoft .Net/Microsoft SQL software applications.
Get notified when a new post is published.
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.