oracle分页查询:
第1页,每页10条数据
select * from (select rownum rn,x.* from (select * from customer) x where rownum<=1*10) where rn > (1-1)*10;
第2页
select * from (select rownum rn,x.* from (select * from customer) x where rownum<=2*10) where rn > (2-1)*10;
oracle分页查询:
第1页,每页10条数据
select * from (select rownum rn,x.* from (select * from customer) x where rownum<=1*10) where rn > (1-1)*10;
第2页
select * from (select rownum rn,x.* from (select * from customer) x where rownum<=2*10) where rn > (2-1)*10;