Find duplicate rows in a table - SQL Snipplr Social Repository

Revision: 43379

at March 23, 2011 02:13 by samwa

Initial Code

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

Initial URL

http://www.petefreitag.com/item/169.cfm

Initial Description

Initial Title

Find duplicate rows in a table

Initial Tags

sql

Initial Language

SQL