逻辑查询处理的步骤
--邏輯查詢處理的步驟序號(hào)
(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 技術(shù)內(nèi)幕:T-SQL查詢,即卷一,,inside t-sql QUERY
(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 技術(shù)內(nèi)幕:T-SQL查詢,即卷一,,inside t-sql QUERY
轉(zhuǎn)載于:https://www.cnblogs.com/zerocc/archive/2011/11/14/2249049.html
總結(jié)
- 上一篇: wcf系列---- binding的使用
- 下一篇: 把磁盘崩溃了,总是进去维护模式,却删除不