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

[code lang=”sql”]
SELECT * FROM tableName
GROUP BY columnName
HAVING ( COUNT( columnName) >1 )
[/code]

Categories: ContentGeneral

Leave a Reply

Your email address will not be published. Required fields are marked *