查询处理的逻辑顺序

(8) select (9) [Distinct]

(11) [Top n] 返回结果列表 [into 新表名称]

(1) from 表

(3) [Inner | left | right] join 表 (2) on < 表join的条件>

(4) [where <过滤条件>]

(5) [Group by <分组语法>]

(6) [with {cube | rollup}]

(7) Having <过滤条件>

(10) order by <排序列表> asc| desc