oracle 别名,该怎么处理
oracle 别名
select * from (select * from (select * from table1 where col1=(select max (col1) from table1 ) ) as a where col2 =(select max (col2) from a )) as b where col3 =(select max(col3) from b )
为什么里面的别名失效呢？
------解决方案--------------------
你分层搞清楚啊
------解决方案--------------------
只有外层能用相邻内层的别名。
select * from (select * from (select * from table1 where col1=(select max (col1) from table1 ) ) as a where col2 =(select max (col2) from a )) as b where col3 =(select max(col3) from b )
为什么里面的别名失效呢？
------解决方案--------------------
你分层搞清楚啊
------解决方案--------------------
只有外层能用相邻内层的别名。