oracle remove duplicates - ghdrako/doc_snipets GitHub Wiki

delete
 from   dup_drivers
 where  rowid in (
   select rid
   from   (select rowid as rid
                , row_number() over (partition by driverid order by null) as rn
            from   dup_drivers)
   where  rn > 1)
 /