7.23 Set functions

Set functions can be used to calculate aggregated strings across multiple rows. The set functions are listed in the following table.

Table 7‒21: List of set functions
No.	List of set functions		Description
1	COUNT(*)		Determine the row count (number of results).
2	General set functions	AVG	Determine the average of the retrieved values.
3		COUNT	Determine the row count (number of results).
4		MAX	Determine the maximum value.
5		MIN	Determine the minimum value.
6		SUM	Determine the sum of the retrieved values.
7		STDDEV_POP	Determine the standard deviation of a population.
8		STDDEV_SAMP	Determine the standard deviation of a sample.
9		VAR_POP	Determine the variance of a population.
10		VAR_SAMP	Determine the variance of a sample.
11	Inverse distribution functions	MEDIAN	Determine the median of an ordered set of values. The value might be linearly interpolated.
12		PERCENTILE_CONT	Determine the percentile of an ordered set of values. The value might be linearly interpolated.
13		PERCENTILE_DISC	Determine the percentile of an ordered set of values. It returns a result from the set of values.
14	LISTAGG set function	LISTAGG	Concatenate a series of ordered values and insert a separator character string between the values to obtain a string.
15	ARRAY_AGG set function	ARRAY_AGG	Returns an array data of the results of the value expressions specified for the target data (the values compiled by the value expressions), with the array elements in order from the top to the bottom.

Organization of this section

To Page Top