MSSQL Aggregate Functions 20 codes

  1. Home
  2. MSSQL
  3. Aggregate Functions
1 AVG
2 AVG returns the average of the values in expression
3 AVG() function returns the average for a range of numeric values, for all non-null values
4 Both the MIN and the MAX
5 Combine MAX function with group by
6 Combine MIN function with group by
7 Count distinct values
8 Count with group by
9 Count() from a table
10 COUNT() function returns an integer value for the number of non-null values in the column range
11 COUNT_BIG
12 COUNT_BIG deals with NULL values
13 GROUP BY with the SUM() function
14 MAX
15 MIN
16 Null value is eliminated by an aggregate or other SET operation
17 The COUNT() function ignores NULL values
18 Use count() to count row number
19 Use sum function in a table join
20 Use SUM function with having clause