Delete duplicates for ms sql

DeleteDuplicates.sql

-- FIELD is the unique field to find duplicates on
delete TABLENAME
from TABLENAME
    left outer join (
        select min([Key]) as [Key], FIELD
        from TABLENAME
        group by FIELD
    ) as temp on
    TABLENAME.[Key] = temp.[Key]
    where temp.[Key] is null