oracle 分页查找数据

select * from sa_task where sid in(select sid from (
select rownum rn,sid from(
select sid,screatetime from 
sa_task order by screatetime desc
) where rownum<10
) where rn>4) order by screatetime desc;

limit：一次取的条数；

offset:从第几条开始取；

bigint toNumber = limit+ offset +1 取到第几条；

String sql = "select * from sa_task where sid in(select sid from (
select rownum rn,sid from(
select sid,screatetime from 
sa_task order by screatetime desc
) where rownum<"+toNumber+"
) where rn>"+ offset +") order by screatetime desc";