第三章：数据查询语言DQL-group by和having的使用

直接学习：https://edu.csdn.net/course/play/27328/362529
group by和having的使用：
#group by表示根据某种规则对数据进行分组，它必须配合聚合函数进行使用，对数据进行分组后，可以进行count ,avg , sum, max,min等运算。
1、select sex , count() from employee group by sex;
2、select dept , count() from employee group by dept;
3、select dept , sum(salary) from employee group by dept;
4、select dept , max(salary) from employee group by dept;
5、select dept , min(salary) from employee group by dept;
#在SQL中增加having 子句的原因是，where关键字无法与聚合函数一起使用，having子句可以对分组后的各组数据进行筛选。
1、select dept , count() from employee group by dept having count()<5;
2、select dept , max(salary) from employee group by dept having max(salary)>10000;