The following table contains a full list of the aggregate functions in MySQL.
Name | Description |
---|---|
AVG() | Returns the average value of its argument. |
BIT_AND() | Returns the bitwise AND. |
BIT_OR() | Returns the bitwise OR. |
BIT_XOR() | Returns the bitwise XOR. |
COUNT() | Returns a count of the number of rows to be returned by a query. |
GROUP_CONCAT() | Returns a concatenated string. |
JSON_ARRAYAGG() | Returns the result set as a single JSON array. |
JSON_OBJECTAGG() | Returns the result set as a single JSON object. |
MAX() | Returns the maximum value. |
MIN() | Returns the minimum value. |
STD() | Returns the population standard deviation. |
STDDEV() | Returns the population standard deviation. |
STDDEV_POP() | Returns the population standard deviation. |
STDDEV_SAMP() | Returns the sample standard deviation. |
SUM() | Returns the sum. |
VAR_POP() | Returns the population standard variance. |
VAR_SAMP() | Returns the sample variance. |
VARIANCE() | Returns the population standard variance. |