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