MySQL 查询结果分组 group by

[group by {col_name | position} [ASC | DESC ]]

分组条件

[HAVING where_condition]

HAVING 后面的条件必须出现在select语句中

原文地址:https://www.cnblogs.com/wangshuyi/p/6489732.html