关于SELECT 逻辑的执行顺序问题

不会有大多数人都和我一样的认为，是先进行的Where 剔除结果集，再进行Join的吧

 

SQL server 2014 逻辑执行标准：

https://msdn.microsoft.com/en-us/library/ms189499(v=sql.120).aspx

FROM

1. FROM

2. ON

3. JOIN

4. WHERE

5. GROUP BY

6. WITH CUBE or WITH ROLLUP

7. HAVING

8. SELECT

9. DISTINCT

10. ORDER BY

11. TOP

Oracle 12c 逻辑执行标准

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_10002.htm