SQL逻辑查询处理的步骤序号

(8)SELECT (9) DISTINCT <select_list>

(1)FROM <left_table>

(3)<join_type>JOIN<right_table>

(2)ON<join_condition>

(4)WHERE<where_condition>

(5)GROUP BY<group_by_list>

(6)WITH {CUBE|ROLLUP}

(7)HAVING<havint_condition>

(10)ORDER BY <order_by_list>

(11)LIMIT<limit_number>

 

posted @ 2019-04-10 22:44  夜幕长安  阅读(103)  评论(0)    收藏  举报