在表a中有1000条数据,用pl/sql查询显示分页,每页显示20个数据用三层嵌套
select * from
(select rownum no,b.* from
(select * from a order by code asc) b
where rownum <= 20) c
where c.no >= 1; 这样只能实现显示1到20的数据,请问怎么显示后面的?
select * from
(select rownum no,b.* from
(select * from a order by code asc) b
where rownum <= 20) c
where c.no >= 1; 这样只能实现显示1到20的数据,请问怎么显示后面的?
select *
from
(
select row_number over(order by code ) rn,a.* from a
) b
where b.rn between 1 and 20
如果是显示第二21到40,就把where换成
where b.rn between 21 and 40
select *
from
(
select row_number() over(order by code ) rn,a.* from a
) b
where b.rn between 1 and 20