A group function is a function that is applied to a group of rows, in other words, a group function operates on a group of values. The following table gives a description of the MySQL group functions -
Mr. No. | Name and Description |
---|---|
AVG()Returns the average value of the parameters. | |
BIT_AND() Returns the bitwise AND. | |
BIT_ORIt returns a bitwise OR. | |
BIT_XOR()Returns bitwise XOR. | |
COUNT()It returns the number of rows returned. | |
COUNT(DISTINCT)Returns the count of numeric distinct values. | |
GROUP_CONCAT()It returns a connection string. p> |
|
MAX()It returns the maximum value. p> |
|
MIN()It returns the minimum value. p> |
|
ST()It returns the population standard deviation. | |
STDDEV()It returns the population standard deviation. | |
STDDEV_POP()It returns the population standard deviation. | |
STDDEV_SAMP()It returns the sample standard deviation. | |
SUM()It returns the sum. | |
VAR_POP()It returns the population standard deviation. | |
VAR_SAMP()It returns the sample variance. p> |
|
Variance()It returns the population standard deviation. |
The above is the detailed content of What are MySQL group functions?. For more information, please follow other related articles on the PHP Chinese website!