PostgreSQL Aggregate Functions

19 functions

COUNTCOUNT(expr)

Returns the count of non-NULL rows.

SUMSUM(expr)

Returns the sum.

AVGAVG(expr)

Returns the average.

MINMIN(expr)

Returns the minimum value.

MAXMAX(expr)

Returns the maximum value.

STRING_AGGSTRING_AGG(expr, sep [ORDER BY ...])

Concatenates strings with a separator.

ARRAY_AGGARRAY_AGG(expr [ORDER BY ...])

Aggregates values into an array.

JSON_AGGJSON_AGG(expr)

Aggregates values into a JSON array.

JSONB_AGGJSONB_AGG(expr)

Aggregates values into a JSONB array.

JSON_OBJECT_AGGJSON_OBJECT_AGG(key, value)

Aggregates key-value pairs into a JSON object.

BOOL_ANDBOOL_AND(expr)

Returns true if all values are true.

BOOL_ORBOOL_OR(expr)

Returns true if any value is true.

BIT_ANDBIT_AND(expr)

Returns the bitwise AND aggregate.

BIT_ORBIT_OR(expr)

Returns the bitwise OR aggregate.

STDDEV_POPSTDDEV_POP(expr)

Returns the population standard deviation.

STDDEV_SAMPSTDDEV_SAMP(expr)

Returns the sample standard deviation.

VAR_POPVAR_POP(expr)

Returns the population variance.

VAR_SAMPVAR_SAMP(expr)

Returns the sample variance.

CORRCORR(y, x)

Returns the correlation coefficient.