SELECT Duplicate Items Using SQL

Published on 20 December 2011

Author: Andrew

Estimated reading time: 1 min

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

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

Published on 20 December 2011