select * from (select rownum r_, row_.* from (select * from student order by id ) row_ where rownum <=5) where r_>=1
1位置:起始索引位置。
5位置:结束索引位置。