SQL SERVER: Delete Duplicate Rows With Primary Id
Join the DZone community and get the full member experience.Join For Free
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)
Opinions expressed by DZone contributors are their own.