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 标准的 SQL 的解析顺序为: (1).FROM 子句, 组装来自不同数据源的数据(2... 阅读全文
posted @ 2009-07-30 13:57 风乔 阅读(171) 评论(0) 推荐(0) 编辑