sql语句执行顺序

sql语句执行顺序

一个sql语句，在执行过程中顺序如下：
执行顺序：FROM→JOIN→WHERE→GROUP BY→HAVING→SELECT→ORDER BY

FOR EXAMPLE（注释中序号表示执行顺序）:

SELECT /*··········································第5.选择需要展示的字段*/
	d.name AS dept,
	count( u.id ) AS count,
	d.no sort 
FROM
	USER u /*······································第1.先获取user表中所有数据*/
	LEFT JOIN department d ON u.id = d.id  /*······第2.获取按条件获取关联表中所有数据*/
WHERE /*···········································第3.进行where筛选*/
	d.name IS NOT NULL 
GROUP BY /*········································第4.进行字段排序*/
	u.id 
ORDER BY /*········································第6.进行数据排序，ASC升序，DESC降序，默认ASC*/
	d.no
LIMIT 8; /*········································第7.限制展示行数*/

执行结果如下：