deleting duplicates from oracle table Using self-join

Post date: 13-Oct-2015 13:10:26

delete from temp t1

where rowid not in

(select max(rowid) from temp t2

where t1.unique_id = t2.unique_id );