Finding Duplicates with SQL

Posted on December 1, 2017 by Chandan Sharma in CodeIgniter, PHP

#Finding Duplicates with SQL::

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


For Single Occurance Use::

SELECT email
FROM users
GROUP BY email
HAVING ( COUNT(email) = 1 )

Published by Chandan Sharma

View all posts by Chandan Sharma

Leave a Reply Cancel reply