ora-00907:缺少右括号

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