Finding Duplicates with SQL::
SELECT `email`,
COUNT(`email`) AS NumOccurrences
FROM `user`
GROUP BY `email`
HAVING ( COUNT(`email`) > 1 )
SELECT `email`,
COUNT(`email`) AS NumOccurrences
FROM `user`
GROUP BY `email`
HAVING ( COUNT(`email`) > 1 )
No comments:
Post a Comment