over partition by order by

SQL Server Lag Function

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.

SQL Server Lead Function

SQL Server LEAD() function is a Analytics function that provides access to a row at a specified physical offset which follows the current row.

Basically, LEAD() function provides access to a row at a given physical offset that follows the current row.