RSA Scripts

Delete duplicated rows

Delete duplicated rows.

  1. Oracle
  2. Table manipulations
  3. Beginner
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

delete from PENSIONERIM
 where rowid in (select rowid 
                   from (select rowid,
                                row_number()
                                over 
                                (partition by PensionerId,fund order by PensionerId,fund) dup
                           from PENSIONERIM
                          where funddate=to_date('01/12/2014','dd/mm/yyyy'))
                  where dup > 1);