书写sql语句时各关键字的顺序(从左往右):
select from where group by having order by
执行顺序(从左往右):
from where group by having select order by
FROM:将数据插入内存
WHERE :用where过滤器对数据进行过滤,将满足条件的留下
GROUP BY : 会将刚刚的结果的临时表进行切分成若干个临时表
HAVING:对结果进行过滤,形成一张新表。
ORDER BY:对数据进行排序
select:查询