Query Problem

[Humanski]

Hello

I have a problems how would I write : -

If Ref_no is equal to Ref_no then delete 1 of the records

REF_NO
12345
REF_NO
12345

This would be a match so I would like to delete one of these records, is there a way to do this with SQL.

 

[Sohaila Taravati]

You can make a query through the wizred to find duplicates and then make a delete query out of the duplicate query.