MySQL - Aggregate Functions

In general, aggregation is a consideration of a collection of objects that are bound together as a single entity. MySQL provides a set of aggregate functions that perform operations on all the entities of the column of a table considering them as a single unit. Following are the MySQL aggregate functions −

Sr.No. Name & Description
1 AVG()

This function is used to calculate the average value.
2 BIT_AND()

This function is used to calculate the bitwise AND value.
3 BIT_OR()

This function is used to calculate the bitwise OR value.
4 BIT_XOR()

This function is used to calculate the bitwise XOR value.
5 COUNT()

This function is used to count the number of rows returned.
6 GROUP_CONCAT()

This function returns the concatenated string.
7 JSON_ARRAYAGG()

This function returns the given values as a single JSON array.
8 JSON_objectAGG()

This function returns the given values as a single JSON object.
9 MAX()

This function returns the maximum value.
10 MIN()

This function returns the minimum value.
11 STD()

This function calculates and returns the population standard deviation.
12 STDDEV()

This function calculates and returns the population standard deviation.
13 STDDEV_POP()

This function calculates and returns the population standard deviation.
14 STDDEV_SAMP()

This function calculates and returns the sample standard deviation.
15 SUM()

This function is used to calculate the sum of the values.
16 VAR_POP()

This function calculates and returns the population standard variance.
17 VAR_SAMP()

This function calculates and returns the sample variance.
18 VARIANCE

This function calculates and returns the population standard variance.
Advertisements