oracle 别名作为where后面的过滤条件
如题,
select (这里是子查询) as aa from table1 where aa='123';
这样会报错,求解决方案,
1.with temp as (select (这里是子查询) as aa from table1 where aa='123' )
select * from temp;
2.select * from (select (这里是子查询) as aa from table1 where aa='123' )
这样可以,但是要改很多代码,求有没有更为简便的方法。
一直在线等,,,