SQL Analytic Functions

The following are the list of SQL Server Analytic or analytical functions.

1. Cume_Dist
2. First_Value
3. Last_Value
4. Lag
5. Lead
6. Percentile_Cont
7. Percentile_Disc
8. Percent_Rank