Skip to Main Content

SQL Query on setting up the previous value of the adjacent column to the other column

Gayathri VenugopalMar 27 2019 — edited Mar 31 2019
DayEndReorderSalesDayInventoryQuantityDayStart
390392564
6454106575
756510818

Above is the output of the expected data. From the second row of DayEnd, I need to take the value of the previous row of the DayStart.How do I do that.If you observe the values of  DayEnd, it would have the data of the previous row value of the DayStart.

Comments
Post Details
Added on Mar 27 2019
7 comments
731 views