DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
SQL SERVER: Delete Duplicate Rows With Primary Id
Deletes duplicates (leaving one instance) where the table has a primary key. Good for tables with Id, DupColumn, DupColumn...
(This is MS-SQL specific)
DELETE
FROM TableName
WHERE Id NOT IN
(SELECT MAX(Id)
FROM TableName
GROUP BY DuplicateColumName1, DuplicateColumName2)
