ORA-00907: 缺失右括号
select ID,MAILTYPE,MAILTITLE,to_char(WRITETIME,'yyyy-mm-dd') WRITETIME from mails where ID in (select ID from mails where ISPUB=1 and ISVAIDATE=1 and ISSECRET=0 and ISCHOOSEPUB=1 order by ID desc) and rownum<11


哪里缺右括号了?
不明白

[解决办法]
在IN 里为什么加order by
[解决办法]
子查询里不能有ORDER BY
[解决办法]
对了，子查询不可以有 order by
[解决办法]
嗯，子查询里不能有ORDER BY