SQL逻辑查询处理的步骤序号
1 (8)SELECT (9)DISTINCT (11)<Top Num> <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>
原文：http://www.cnblogs.com/zhaoyuncai/p/4980728.html