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. |
”;