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]