Analytic functions

Analytics Platform System (PDW)

Azure SQL Edge

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

SELECT - OVER clause (Transact-SQL)