Dec 6, 2007

Delete duplicate rows in Table - Oracle

delete from TABLE_NAME t1
where t1.rowid >
( select min(t2.rowid) from TABLE_NAME t2
where t1.COLUMN_1 = t2.COLUMN_1
and t1.COLUMN_2 = t2.COLUMN_2);

No comments: