What are MySQL group functions?

Group functions are the function which applied to a group of rows or in other words group functions operate on sets of values. The following table gives the Description of MySQL group functions −

Sr.No. Name & Description
1 AVG()
It returns the average value of the argument.
2 BIT_AND()
It returns bitwise AND.
3 BIT_OR
It returns bitwise OR.
4 BIT_XOR()
It returns bitwise XOR.
5 COUNT()
It returns a count of the number of rows returned.
6 COUNT(DISTINCT)
It returns the count of a number of different values.
7 GROUP_CONCAT()
It returns a concatenated string.
8 MAX()
It returns the maximum value.
9 MIN()
It returns the minimum value.
10 ST()
It returns the population standard deviation.
11 STDDEV()
It returns the population standard deviation.
12 STDDEV_POP()
It returns the population standard deviation.
13 STDDEV_SAMP()
It returns the sample standard deviation.
14 SUM()
It returns the sum.
15 VAR_POP()
It returns the population standard variance.
16 VAR_SAMP()
It returns the sample variance.
17 Variance()
It returns the population standard variance.
Updated on: 2020-06-22T08:04:31+05:30

199 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements