Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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: 22-Jun-2020
106 Views
Advertisements