Sql: select * from (select results.*,rownum rn from (
select
t1.*
from
wemall_store t1
where
1 = 1
and t1.store_status = 2
and t1.deletestatus = 0
order by t1.addTime desc
) results where rownum <=10) where rn>=0;
com.jfinal.plugin.activerecord.ActiveRecordException: java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符
但语句在navcat是可以直接执行的,求解
项目：JFinal
也可以打开 show sql 在控制台得到 sql ，再去 navicat 中去执行，打开方式为:
arp.setShowSql(true);