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