ORACLE 分页 java 用jdbc方式以 sys账号连接oracle数据的问题

2，3，4，6，8 betwenen 为闭区间，前后都包括

select * from(select a.*,rownum rn from (select * from student) a ) where rn between 1 and 3;