从第N条取到第M条记录
select * from (select rownum rn , yourTable.* from yourTable where rownum < M+1) tmpTable where tmpTable.rn between N and M
从第N条开始取M条记录
select * from (select rownum rn , yourTable.* from yourTable where rownum < N+M+1) tmpTable where tmpTable.rn between N and N+M
注:M>N