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>

SQL 执行顺序

原文：http://www.cnblogs.com/Elsie/p/4546443.html