DZone Snippets: SQL Server code http://snippets.dzone.com/posts Tue, 07 Oct 2008 13:50:16 GMT DZone Snippets: SQL Server code SQL SERVER: Delete Duplicate Rows with Primary Id http://snippets.dzone.com/posts/show/4482 Deletes duplicates (leaving one instance) where the table has a primary key. Good for tables with Id, DupColumn, DupColumn... <br /> <br />(This is MS-SQL specific) <br /> <br /><code> <br />DELETE <br />FROM TableName <br />WHERE Id NOT IN <br /> (SELECT MAX(Id) <br /> FROM TableName <br /> GROUP BY DuplicateColumName1, DuplicateColumName2) <br /></code> Fri, 31 Aug 2007 19:12:09 GMT http://snippets.dzone.com/posts/show/4482 cornerblue (CornerBLUE, Inc.)