• Thanks Koen for the suggestion.

    The query I had in mind was incomplete. It should be like this:

    ALTER TABLE [Table Name] ADD AUTOID INT IDENTITY(1,1)

    DELETE FROM [Table Name] WHERE AUTOID NOT IN (SELECT min(autoid) FROM [Table Name]

    GROUP BY [Field1],[Field2]