oracle报错SQL:
select * from "ManagementYY"
where 1=1 and rownum<=50 and YYLSH not in (select YYLSH from "ManagementYY" where 1=1 and rownum<=0 order by YYLSH) order by YYLSH
原因:子查询中不能用 order by YYLSH;
解决办法:KILL order by YYLSH
oracle报错SQL:
select * from "ManagementYY"
where 1=1 and rownum<=50 and YYLSH not in (select YYLSH from "ManagementYY" where 1=1 and rownum<=0 order by YYLSH) order by YYLSH
原因:子查询中不能用 order by YYLSH;
解决办法:KILL order by YYLSH