SQL Find Duplicates
Snippet Menu
2
Fri. Jul. 20th, 2007 7:28 PM
Very simple script that you can use to find duplicated rows in SQL or you can use it to count same rows eg. Top 10 posters script or something like that... very usefull
SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )
Sasa Karanovic
Sasa Karanovicwww.MrdniSe.com
www.SasaKaranovic.com
Comments
Voting
Votes Up
Votes Down
There are currently no comments for this snippet.