In Sql Server How to Shift Rows for Two Columns [Closed]

Name: In Sql Server How to Shift Rows for Two Columns [Closed]
Uploaded: 2026-09-27T14:15:52+00:00
Duration: 8 min 35 s
Description: This Is the Original Table Name Marks_Original Anil 10 Ravi 20 Pooja 30 Sheela 40 Rohit 50 Vijay 60 I Want the Output Using 2 Calculated Columns as Below Where...

Question

This is the original table

Name    Marks_Original
Anil    10
Ravi    20
Pooja   30
Sheela  40
Rohit   50
Vijay   60

I want the output using 2 calculated columns as below where my 1st column record is static but my 2nd column records are shifting up and down respective to 1st column

Name    Marks_1  Marks_2
Anil    0        20
Ravi    10       30
Pooja   20       40
Sheela  30       50
Rohit   40       60
Vijay   50       0

Accepted Answer

Try the window functions (assuming the sequence is Marks_Original)

Select *
      ,Marks_1 = Lag(Marks_Original,1,0) over (Order By Marks_Original)
      ,Marks_2 = lead(Marks_Original,1,0) over (Order By Marks_Original)
 From  YourTable
 Order By Marks_Original

Returns

Name    Marks_Original  Marks_1 Marks_2
Anil    10              0       20
Ravi    20              10      30
Pooja   30              20      40
Sheela  40              30      50
Rohit   50              40      60
Vijay   60              50      0

In Sql Server How to Shift Rows for Two Columns [Closed]

Must Read

1 Answer

Sophia Al-Mansoor