查詢處理的邏輯順序

(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

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/16436858/viewspace-616534/，如需轉載，請註明出處，否則將追究法律責任。