Oracle取特定记录

从第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