select*from(select rownum rn,t.*from tb t
) a where a.rn>(pageNo-1)*pageSize and a.rn < pageNo*pageSize+1--每页显示5条 select rownum rn,t.*from emp t;
select*from(select rownum rn,t.*from emp t
) a where a.rn>10and a.rn <16;
方法2 语法:效率高,没有查询全部数据
select*from(select rownum rn,t.*from tb t where rownum< pageNo*pageSize+1) a where a.rn> (pageNo-1)*pageSize
--每页显示5条 select rownum rn,t.*from emp t;select*from(select rownum rn,t.*from emp t where rownum<16) a where a.rn>10;
错误写法
select rownum rn,t.*from emp t;select*from(select rownum rn,t.*from emp t where rownum >5) a where a.rn<11;