| AVG(expression) |
the average (arithmetic mean) of all input values |
Finding the average value is available on the following data types: smallint, integer, bigint, real, double precision, numeric, interval. The result is of type numeric for any integer type input, double precision for floating-point input, otherwise the same as the input data type. |
count(*) |
number of input values |
The return value is of type bigint. |
count(expression) |
Counts the input values for which the value of expression is not NULL. |
The return value is of type bigint. |
max(expression) |
the maximum value of expression across all input values |
Available for all numeric, string, and date/time types. The result has the same type as the input expression. |
min(expression) |
the minimum value of expression across all input values |
Available for all numeric, string, and date/time types. The result has the same type as the input expression. |
stddev(expression) |
the sample standard deviation of the input values |
Finding the standard deviation is available on the following data types: smallint, integer, bigint, real, double precision, numeric. The result is of type double precision for floating-point input, otherwise numeric. |
sum(expression) |
sum of expression across all input values |
Summation is available on the following data types: smallint, integer, bigint, real, double precision, numeric, interval. The result is of type bigint for smallint or integer input, numeric for bigint input, double precision for floating-point input, otherwise the same as the input data type. |
variance(expression) |
the sample variance of the input values |
The variance is the square of the standard deviation. The supported data types and result types are the same as for standard deviation. |