mysql 查询先 having 再 group by 分组

查询时函数处理后的字段的别名无法作为 where 的条件，可以作为 having 的条件，这时用 having 筛选后再分组就会报错，因为 having 不能用在 group by 之前，所以我们可以先把 having 筛选后的记录作为一个整体，然后再去分组，代码如下。

select count(one.keywrod) as num one.keyword (select A.a as keyword, B.b from A
left join B on A.a = B.b
where A.c = ""
having keyword = B.z) as one
group by one.keyword