Analytic functions (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Azure SQL Edge SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric

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. Use analytic functions to compute moving averages, running totals, percentages or top-N results within a group.

The Microsoft SQL Database Engine supports these analytic functions:

• ANY_VALUE
• CUME_DIST
• FIRST_VALUE
• LAG
• LAST_VALUE
• LEAD
• PERCENT_RANK
• PERCENTILE_CONT
• PERCENTILE_DISC

Related content

• SELECT - OVER clause (Transact-SQL)