当前位置: 代码迷 >> Java Web开发 >> 一条oracle语句的书写,该如何解决
  详细解决方案

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

热度:156   发布时间:2016-04-17 01:07:54.0
一条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");
  相关解决方案