Lag function example in SQL

SQL Server LAG() function is a Analytics Functions that provides access to a row at a given physical offset that comes before the current row.