RSA Scripts

Delete duplicate rows

Delete duplicate rows. We delete all rows accept one.

  1. Sql Server
  2. Table manipulation
  3. Intermediate
  4. Vaknin Sammy

Last updated:

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

Back to results

WITH cte AS (
  SELECT  polisa as b,
        row_number() OVER ( PARTITION BY  polisa ORDER BY polisa) AS nr
  FROM  [DATA_PENSION_122015_AMLOT]
)
DELETE cte WHERE nr > 1