--在查询的第二层通过ROWNUM <= ??? 来控制最大值,在查询的最外层控制最小值
select * from (select a.*,rownum rn from (select * from sa_staff_info) a where rownum <=2800) where rn >=2780;
--在查询的最外层控制分页的最小值和最大值
select * from (select a.*,rownum rn from (select * from sa_staff_info) a ) where rn between 2780 and 2800;