1、
select * from
(select t.*,ROWNUM s from TABLE_NAME t) k
where k.s between 246 and 246
2、
select /*+ FIRST_ROWS */ * FROM
