How Do I Select Duplicate Records from a Database Table

Posted by: Imar Spaanjaars at Saturday, November 08, 2003 8:33:39 PM in: T-SQL
This T-SQL snippet allows you to select duplicate records from a database table. The example assumes that the column Id is used to determine whether a record has a duplicate. If multiple columns determine whether a record has a duplicate or not, simply expand the SELECT list and the GROUP BY clause.
Read on ... 1