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!
What does java routing mean?
What to do if there is no sound from the computer microphone
What is the difference between php and java
What does root server mean?
js string to array
How to buy, sell and trade Bitcoin
Can Douyin sparks be lit again if they have been off for more than three days?
What is the difference between USB-C and TYPE-C
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
