lag function using partition by

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.