SELECT Duplicate Items Using SQL

2011-12-20

36 words - 1 min read

If you have a table which has duplicate items in then you can use the below statement to select them.

1
2
3

SELECT * FROM tableName
GROUP BY columnName
HAVING ( COUNT( columnName) >1 )