RSA Scripts

Compare rows value on the same table

We use the function row_number() to generate a new column with a value of 1 when ever the next row column value has been changed.

  1. Sql Server
  2. Dml
  3. Advanced
  4. Vaknin Sammy

Last updated:

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

Back to results

UPDATE A
      SET DEGEL = 1
  FROM TABLE1 A INNER JOIN ( SELECT A.COLUMN1, MAX(A.COLUMN2) COLUMN2
                                                     FROM ( SELECT TOP 100 PERCENT COLUMN1,COLUMN2, ROW_NUMBER() OVER(PARTITION BY COLUMN3                                                                                                    ORDER BY COLUMN1,COLUMN2) AS RN
                                                                     FROM TABLE1
                                                                   ORDER BY COLUMN1,COLUMN2) A
                                                  WHERE A.RN = 1
                                                 GROUP BY A.COLUMN1) B ON A.COLUMN1 = B.COLUMN1 AND A.COLUMN2 = B.COLUMN2;