MySQL基础学习笔记——SQL执行顺序

SQL执行顺序

(8)  SELECT (9)DISTINCT<select_list>
(1)  FROM <left_table>
(2)  <join_type>JOIN<right_table>
(3)  ON <join_condition>
(4)  WHERE <where_condition>
(5)  GROUP BY <group_by_list>
(6)  WITH {CUBE|ROLLUP}
(7)  HAVING<having_condition>
(10) ORDER BY<order_by_list>
(11) LIMIT <limit_number>