摘要： 理解T-SQL的逻辑查询顺序是学习SQL Server的基础。 T-SQL逻辑执行顺序 (8) SELECT (9) DISTINCT (11) (1) FROM (3) JOIN (2) ON (4) WHERE (5) GROUP BY (6) WITH {CUBE | ROLLUP} (7) HAVING (10) ORDER BY 注释 (1) 执行笛卡尔乘积。如果有多个表JOIN, 则逻辑执行顺序可以理解成: 先执行INNER JOIN, 再执行OUTER JOIN；或者理解成：按表出现的顺序逐个JOIN。当然，实际的执行顺序有赖于实... 阅读全文