SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )
Showing posts with label sql. Show all posts
Showing posts with label sql. Show all posts
Sunday, October 26, 2008
Finding Duplicates with sql
Subscribe to:
Posts (Atom)
