A. Issue the following query substituting tablename and column list for those columns that need checking for duplicates.
SELECT <list of all columns> FROM tablename GROUP BY <list of all columns> HAVING count(*) > 1
Learn more from How can I delete duplicate rows from a SQL Server tables? and Q. How can I remove duplicates from a list of entries?
2 comments
Hide comments