W3cubDocs

/MariaDB

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.
https://mariadb.com/kb/en/aggregate-functions/