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. |
||