RSA Scripts

Delete duplicat rows

Delete duplicat 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 app_schema.ANNUAL_REPORT_2010
WHERE rowid not (SELECT MIN(rowid)
                              FROM app_schema.ANNUAL_REPORT_2010
                           GROUP BY MISPAR_TZ, KOD_SUG_KEREN);