第十课 分组数据
一、创建分组 Group BY
SELECT
age,
gender,
city
FROM inf
GROUP BY age
;
二、过滤分组 HAVING
注意:having过滤分组;where过滤行
SELECT
age,
gender,
city
FROM inf
WHERE age>23
GROUP BY age
HAVING gender >=1
;
三、分组和排序
注意:GROUP BY 只能对SELECT列使用;order by 对所有列都能使用