Find duplicate entries - SQL Snipplr Social Repository

Revision: 53133

at January 26, 2012 23:34 by Neven

Updated Code

SELECT     column1, COUNT(*) AS Expr1
FROM         table1 
GROUP BY column1
HAVING      (COUNT(*) > 1)

Revision: 53132

at November 14, 2011 23:07 by Neven

Initial Code

SELECT     InternalName, COUNT(*) AS Expr1
FROM         MetricType
GROUP BY InternalName
HAVING      (COUNT(*) > 1)

Initial URL

Initial Description

Searches for duplicate entries in the DataBase table

Initial Title

Find duplicate entries

Initial Tags

sql

Initial Language

SQL