逻辑查询处理的步骤

--逻辑查询处理的步骤序号
(8) SELECT (9) DISTINCT (11) <TOP_SPECIFICATION> <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>


摘自：SQL05 技术内幕：T-SQL查询，即卷一，，inside t-sql QUERY