Analytic functions (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) Azure SQL Edge SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric

SQL Server supports these analytic functions:

• CUME_DIST (Transact-SQL)
• FIRST_VALUE (Transact-SQL)
• LAG (Transact-SQL)
• LAST_VALUE (Transact-SQL)
• LEAD (Transact-SQL)
• PERCENT_RANK (Transact-SQL)
• PERCENTILE_CONT (Transact-SQL)
• PERCENTILE_DISC (Transact-SQL)

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.

See also

• OVER Clause (Transact-SQL)