(重点:GROUP BY子句和HAVING子句)
使用having子句时select语句的顺序
from-where-group by-having-select-order by
GROUP BY 单列分组
GROUP BY 多列分组
HAVING子句(对GROUP BY分组后的结果筛选)
(重点:GROUP BY子句和HAVING子句)
使用having子句时select语句的顺序
from-where-group by-having-select-order by
GROUP BY 单列分组
GROUP BY 多列分组
HAVING子句(对GROUP BY分组后的结果筛选)