【MySQL】十二、总结DQL语句的执行顺序

语法

一个完整的DQL语句的语法格式：

select ... from ... where ... group by ... having ... order by ..

执行顺序：

select ...  		5	
from ...   			1
where ... 			2
group by ... 		3
having ... 			4
order by ..			6

1. 从哪张表中查，from
2. 筛选出要求的信息 where
3. 再进行分组 group by
4. 分组后再筛选出有符合要求的信息 having
5. 然后根据字段查出来 select
6. 最后排序输出

在学了limt关键字后（【MySQL】二十、limit的使用（重点），通用SQL分页），执行顺序如下：

select 
	...			5
from
	...			1
where
	...			2
group by
	...			3	
having
	...			4
order by
	...			6
limit
	...			7