Select Duplicates - SQL Snipplr Social Repository

Revision: 32477

at September 26, 2010 03:37 by traeregan

Initial Code

SELECT email, 
 COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )

Initial URL

Initial Description

Initial Title

Select Duplicates

Initial Tags

mysql, sql

Initial Language

SQL