oracle 分页查询
时间:2022-03-15 08:00
select *
from (select rownum as rr,t.* from (select * from emp where sal is not null order by sal)t
where rownum <=10
)where rr>2;
时间:2022-03-15 08:00
select *
from (select rownum as rr,t.* from (select * from emp where sal is not null order by sal)t
where rownum <=10
)where rr>2;