![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
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. |
Advertisements