Oracle基础SELECT语句的逻辑处理顺序

SELECT语句的逻辑处理顺序

5 SELECT <column list>

1 FROM <source object list>

1.1 FROM <left source object> <join type> 

JOIN <right source object> ON <on predicates>

2 WHERE <where predicates>

3 GROUP BY <group by expression(s)>

4 HAVING <having predicates>

6 ORDER BY <order by list>

从上面可以看出SELECT执行不同于其它语言,是从FROM开始的,标记为1.1的FROM子句表示FROM的不同语法。