Removing duplicate detail records

[John]

Hi

I have a contacts table with four fields Contact_ID, Company_ID, Forename
and Surname. As a result of recent data import, many companies have ended up
with duplicate contacts, so for instance Company_ID 109 will have multiple
contacts with the same forename and surname. What is the way to remove such
duplicates such that each company is left with only one contact of a
specific forename+surname set?

Thanks

Regards

 

[John]

How does one delete all duplicate records except one? That is my problem.

Thanks

Regards