Finding Duplicates with SQL

Finding Duplicates with SQL::

SELECT `email`,
 COUNT(`email`) AS NumOccurrences
FROM `user`
GROUP BY `email`

HAVING ( COUNT(`email`) > 1 )

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Save my name, email, and website in this browser for the next time I comment.

Notify me of follow-up comments by email.

Notify me of new posts by email.