So entfernt man Duplikate in einer Oracle-Datenbanktabelle mit Hilfe von "Analytical SQL":
delete from
tabelle
where rowid in
(select rowid from
(select
rowid,
row_number()
over
(partition by feld1,feld2 order by feld1, feld2) dup
from tabelle )
where dup > 1);
