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