SELECT Duplicate Items Using SQL

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 )
Code language: SQL (Structured Query Language) (sql)
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments