RE: Deleting Duplicates

Dear Any One,
You need delete the duplicated records by rowid. Here is the script say the table A has duplicates, you match the duplicates by unique keys(i.e. emp_no)
delete from A E

      where E.rowid > (select min(x.rowid)
                      from A x
                     where x.keys = E.keys);

I hope this is what you are looking for

YK Received on Wed Jun 19 1996 - 00:00:00 CEST