SQL 执行顺序

1 SELECT (9) DISTINCT (11) <TOP_specification> <select_list> 

2 (1) FROM <left_table>  

3 (3) <join_type> JOIN <right_table> 

4 (2) ON <join_condition> 

5 (4) WHERE <where_condition> 

6 (5) GROUP BY <group_by_list> 

7 (6) WITH {CUBE | ROLLUP} 

8 (7) HAVING <having_condition> 

9 (10) ORDER BY <order_by_list>

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。