mysql group by order by havaing where 顺序

 结论：

select xx from xx where xx group by xx order by xxx;

select xx from xx group by xx having xx order by xxx;

===============================

where 跟having 后面都可以跟条件。但是又有很多区别

1 where 的字段必须是表中的字段

2 执行顺序是，先where 后 聚合

3 having 后面的字段不必须是表的字段

4  having 先聚合 后 条件

5 有时where 跟having 可以替换

mysql group by order by havaing where 顺序

原文：https://www.cnblogs.com/guoshuai-yangxu/p/11578805.html