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?