rownum只能做小于等于数值,不能做大于的运算
查询所有记录
假设分页,每页为5行
1、查询数据库netUser表格的前4条记录
select rownum,netUser.*from netUser
where rownum<5;
2、查询第二页信息
方法一:
select rownum,t.* from
( select rownum r,e.*
from netUser e
where rownum<=10)t
where r>5;
方法二:
select * from
(select rownum r ,netUser.*
from netUser) b
where b.r >5 and b.r <11;
方法三
select Uno,userName,userPassword,userJob,usex,uage
from (select rownum rn,u.*
from netUser u) ua
where ua.rn between 6 and 10;