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 |
This function is used to calculate the average value. |
2 |
This function is used to calculate the bitwise AND value. |
3 |
This function is used to calculate the bitwise OR value. |
4 |
This function is used to calculate the bitwise XOR value. |
5 |
This function is used to count the number of rows returned. |
6 |
This function returns the concatenated string. |
7 |
This function returns the given values as a single JSON array. |
8 |
This function returns the given values as a single JSON object. |
9 |
This function returns the maximum value. |
10 |
This function returns the minimum value. |
11 |
This function calculates and returns the population standard deviation. |
12 |
This function calculates and returns the population standard deviation. |
13 |
This function calculates and returns the population standard deviation. |
14 |
This function calculates and returns the sample standard deviation. |
15 |
This function is used to calculate the sum of the values. |
16 |
This function calculates and returns the population standard variance. |
17 |
This function calculates and returns the sample variance. |
18 |
This function calculates and returns the population standard variance. |