Find SQL duplicates - SQL Snipplr Social Repository

Revision: 43312

at March 21, 2011 22:06 by marvin9000

Initial Code

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

Initial URL

Initial Description

Find duplicate records regarding a certain field.

Initial Title

Find SQL duplicates

Initial Tags

sql

Initial Language

SQL