SQL Server LAG Window Function

The LAG function gives access to the data of the preceding rows or the row at a given offset that is preceding the current row in the same result set