2,3,4,6,8 betwenen 为闭区间,前后都包括
select * from(select a.*,rownum rn from (select * from student) a ) where rn between 1 and 3;
desc 降序
2,3,4,6,8 betwenen 为闭区间,前后都包括
select * from(select a.*,rownum rn from (select * from student) a ) where rn between 1 and 3;
desc 降序