Snippets
DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

SQL Find Duplicates

02.22.2006
| 101 views |
  • submit to reddit 
        // find duplicates in a table


SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )
"Starting from scratch" is seductive but disease ridden
-Pithy Advice for Programmers