MSSQL Analytical Functions 26 codes

  1. Home
  2. MSSQL
  3. Analytical Functions
1 Adds a PARTITION setting to the OVER clause
2 Assigning Row Number Values to Rows
3 Basic CUBE Query
4 COMPUTE
5 COMPUTE MIN date
6 COMPUTE SUM(Salary)
7 COMPUTE SUM(Salary) By Name
8 DENSE_RANK()
9 Have both the RANK and DENSE_RANK functions
10 NTILE function demo
11 RANK() Over (ORDER BY Name)
12 ROW_NUMBER()
13 STDEV
14 STDEV ignores NULL values
15 STDEV() Function
16 STDEVP returns the standard deviation for the population of all values in expression
17 Use multiple aggregate functions in a COMPUTE clause
18 VAR returns the statistical variance of values in an expression based on a sample of the provided population
19 VAR returns the variance of all values in expression
20 VAR()
21 VARP returns the variance for the population of all values in expression
22 VARP()
23 When using a different ORDER BY clause in ROW_NUMBER()
24 WITH CUBE
25 WITH ROLLUP
26 WITH ROLLUP, group by and order by