DesNorton
SSC-Insane
Points: 24619
More actions
January 19, 2021 at 8:47 am
#3834912
SQL is not Excel. By default, it cannot see the value in the previous or next row.
However, Window Functions are going to be your new best friend for this task, specifically the LAG function
Viewing post 1 (of 2 total)
You must be logged in to reply to this topic. Login to reply