Deleting duplicates can be done in a single T-SQL command,

when the table has two unique keys that don't have any columns in common.

For a table with only one unique key,...