MySQL Aggregate Functions

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

GROUP_CONCATGROUP_CONCAT([DISTINCT] expr [ORDER BY ...] [SEPARATOR sep])

Concatenates values within a group into a single string.

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

BIT_ANDBIT_AND(expr)

Returns the bitwise AND aggregate.

BIT_ORBIT_OR(expr)

Returns the bitwise OR aggregate.

BIT_XORBIT_XOR(expr)

Returns the bitwise XOR aggregate.