How to identify duplicates in a table....
SELECT email,
Count(email) AS numoccurrences
FROM users
GROUP BY email
HAVING (Count(email) > 1)
Of course, what to do with all those duplicates is up to you!
As I learn more as a DBA: I may as well put it here in one place. This is my personal blog: my opinions are not those of my employer!
No comments:
Post a Comment