the lag function in sql server

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.