一条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");