读书人

一条oracle语句的书写,该如何解决

发布时间: 2012-02-01 16:58:19 作者: rapoo

一条oracle语句的书写
将语句rs=sm.executeQuery("select top "+pageSize+" * from users where userId not in (select top"+pageSize*(pageNow-1)+" userId from users)");转为oracle语句

[解决办法]
试试:
rs=sm.executeQuery("select * from users where userId not in (select userId from users where ROWNUM <= "+pageSize*(pageNow-1)+" ) where ROWNUM <= pageSize");

读书人网 >Java Web开发

热点推荐