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<having_condition>

(10)ORDER BY<order_by_list> 

(11)LIMIT <limit_number>

posted @   ~Sunshine~  阅读(372)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示