deleting only one of the duplicate records in a table w/ composite primary
852658Aug 26 2011 — edited Aug 26 2011I have a table that uses three columns for the primary key.
It has some duplicate records because of some past errors.
How can I delete only one of each duplicate record using a sql statement?
I do not want to do anything that requires dropping the table.
All I have found so far have been ways to drop both duplicate records, not just one of them.
I am sure I could write a pl sql script to do this, but I would just like to know how to do it with sql only if possible. Anyone know how to do this, or does anyone know whether or not this is even possible considering my constraints?
Thanks