7.22 Set functions
Set functions can be used to calculate aggregate values across multiple rows. The set functions are listed in the following table.
No. |
List of set functions |
Description |
|
---|---|---|---|
1 |
Determine the row count (number of results). |
||
2 |
General set functions |
Determine the average value. |
|
3 |
Determine the row count (number of results). |
||
4 |
Determine the maximum value. |
||
5 |
Determine the minimum value. |
||
6 |
Determine the total value. |
||
7 |
Determine the standard deviation of a population. |
||
8 |
Determine the standard deviation of a sample. |
||
9 |
Determine the variance of a population. |
||
10 |
Determine the variance of a sample. |
||
11 |
Inverse distribution functions |
Determine the median value of an ordered set of values. The value might be linearly interpolated. |
|
12 |
Determine the percentile of an ordered set of values. The value might be linearly interpolated. |
||
13 |
Determine the percentile of an ordered set of values. A result from the set of values is returned. |