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 );
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 );