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.
October 7, 1999
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?
You May Also Like