SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY emailHAVING ( COUNT(email) > 1 )
You could also use this technique to find rows that occur exactly once:
SELECT email
GROUP BY email
HAVING ( COUNT(email) = 1 )
Be the first to rate this post
The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
© Copyright 2010
Sign in