Hi all

I have a table with no unique primary index. I want to add a unique primary
key on 2 fields in this table.
The problem is, the older(garbage data) contains duplicates on these 2
fields.

Can anyone help me with the most efficient query that can delete duplicate
records?

Thanks in advance.

Alfred Thomas.