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