What are MySQL group functions?

MySQLMySQLi Database

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
1AVG()
It returns the average value of the argument.
2BIT_AND()
It returns bitwise AND.
3BIT_OR
It returns bitwise OR.
4BIT_XOR()
It returns bitwise XOR.
5COUNT()
It returns a count of the number of rows returned.
6COUNT(DISTINCT)
It returns the count of a number of different values.
7GROUP_CONCAT()
It returns a concatenated string.
8MAX()
It returns the maximum value.
9MIN()
It returns the minimum value.
10ST()
It returns the population standard deviation.
11STDDEV()
It returns the population standard deviation.
12STDDEV_POP()
It returns the population standard deviation.
13STDDEV_SAMP()
It returns the sample standard deviation.
14SUM()
It returns the sum.
15VAR_POP()
It returns the population standard variance.
16VAR_SAMP()
It returns the sample variance.
17Variance()
It returns the population standard variance.
raja
Published on 21-Feb-2018 11:53:04
Advertisements