Skip to content
Home » SQL SERVER » SQL Functions » Analytic Functions

Analytic Functions

SQL Server Analytic functions calculate an aggregate value based on a group of rows. Unlike aggregate functions, however, analytic functions can return multiple rows for each group.

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.

 1,539 total views