DELETE FROM my_table WHERE ROWID <> ( SELECT MAX(ROWID) FROM my_table b WHERE b.c1 = my_table.c1 AND b.c2 = my_table.c2 );The join condition can be used to join the table to itself based on your table's columns. The DELETE statement will remove those duplicate rows without the highest ROWID value.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.