Oracle Aggregate Functions

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

LISTAGGLISTAGG(expr, sep) WITHIN GROUP (ORDER BY ...)

Aggregates values into a string with a separator.

MEDIANMEDIAN(expr)

Returns the median value.

STDDEVSTDDEV(expr)

Returns the sample standard deviation.

STDDEV_POPSTDDEV_POP(expr)

Returns the population standard deviation.

VARIANCEVARIANCE(expr)

Returns the sample variance.

VAR_POPVAR_POP(expr)

Returns the population variance.

CORRCORR(y, x)

Returns the correlation coefficient.

COVAR_POPCOVAR_POP(y, x)

Returns the population covariance.

REGR_SLOPEREGR_SLOPE(y, x)

Returns the slope of the linear regression.

GROUPINGGROUPING(expr)

Returns whether a row is aggregated by ROLLUP/CUBE.

APPROX_COUNT_DISTINCTAPPROX_COUNT_DISTINCT(expr)

Returns an approximate count of distinct values quickly.