How can I find duplicate rows in SQL Server?

Neil Pike

October 7, 1999

1 Min Read
ITPro Today logo in a gray background | ITPro Today

A. Issue the following query substituting tablename and column list for those columns that need checking for duplicates.

SELECT FROM tablenameGROUP BY 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?

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like