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!
Showing posts with label duplicates. Show all posts
Showing posts with label duplicates. Show all posts
Friday, 5 February 2010
Subscribe to:
Posts (Atom)