sql语句中select的查询顺序

2014-11-24 16:57:42 · 作者: · 浏览: 0

sql语句中select的查询顺序
在执行select的时候,找了下select执行的顺序,顺序如下:
(8)SELECT (9)DISTINCT
(11)
(1)FROM
(3) 
JOIN
(2)  ON
(4)WHERE
(5)GROUP BY
(6)WITH {CUBE | ROLLUP}
(7)HAVING
(10)ORDER BY