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";