Aggregate Functions

The following functions (also called aggregate functions) can be used with the GROUP BY clause:

Title Description
Stored Aggregate Functions Custom aggregate functions.
AVG Returns the average value.
BIT_AND Bitwise AND.
BIT_OR Bitwise OR.
BIT_XOR Bitwise XOR.
COUNT Returns count of non-null values.
COUNT DISTINCT Returns count of number of different non-NULL values.
GROUP_CONCAT Returns string with concatenated values from a group.
MAX Returns the maximum value.
MIN Returns the minimum value.
STD Population standard deviation.
STDDEV Population standard deviation.
STDDEV_POP Returns the population standard deviation.
STDDEV_SAMP Standard deviation.
SUM Sum total.
VARIANCE Population standard variance.
VAR_POP Population standard variance.
VAR_SAMP Returns the sample variance.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.