1: Statement order of grouping function1 SELECT ... 2 FROM ... 3 WHERE ... 4 GROUP BY ... 5 HAVING ... 6 ORDER BY ... 2. The difference between WHERE and HAVING filter conditionsData source location keyword WHERE Original table ORDER BY statement before WHERE HAVING Grouped result set after ORDER BY statement HAVING Three: Examples#1. Query the maximum age of students in each classSELECT MAX(age),class FROM STU_CLASS GROUP BY CLASS; # 2. Query the maximum age of male and female students in each class SELECT MAX(age), class, sex FROM STU_CLASS GROUP BY class,sex; #3. Query the average age of boys and girls in each class, and the average age is greater than 15 years old SELECT AVG (age), class, sex FROM STU_CLASS GROUP BY class,sex HAVING avg(age) > 15; Four: Note1. Usually, the GROUP BY keyword is used together with an aggregate function. First, the GROUP BY keyword is used to group the records, and then the aggregate function is used to calculate each group. The GROUP BY keyword and aggregate functions are often needed when performing statistics. The above is the detailed content of the detailed explanation of the group by statement of MySQL database group query. For more information about MySQL database statements, please pay attention to other related articles on 123WORDPRESS.COM! You may also be interested in:
|
<<: Install MySQL (including utf8) using Docker on Windows/Mac
>>: Detailed explanation of Grid layout and Flex layout of display in CSS3
Cluster Deployment Overview 172.22.12.20 172.22.1...
Table of contents Overview The role of reverse pr...
cause The reason for writing this blog is that I ...
Target Display one of the data in the iostat comm...
Table of contents 1. Definition of stack 2. JS st...
Download https://tomcat.apache.org/download-80.cg...
Attribute check-strictly The official document pr...
This article shares with you the specific method ...
Someone asked me before whether it is possible to...
Effective solution for Ubuntu in virtual machine ...
How to write transparent CSS for images using filt...
This article shares with you how to use the Vue c...
The login interface of WeChat applet is implement...
Table of contents Mixin Mixin Note (duplicate nam...
Preface I believe everyone has used the top comma...