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