oracle分页查询

select ti,pri from(    --分页查询
  select rownum rn,ti,pri from(
    select mytitle ti,price pri from rooms
  )t where rownum <6
)where rn>3;

select ti,pri from(    --分页查询
  select rownum rn,ti,pri from(
    select mytitle ti,price pri from rooms
  )t where rownum <=pageSize*pageIndex
)where rn>pageSize*(pageIndex-1);

pageSize表示每页显示的记录数，pageIndex表示当前页数

*****

两层select实现分页

select * from(--分页
  select rownum as rn,v.* from vips v
)where rn>0 and rn<3;