SELECT * FROM (SELECT ROWNUM ROW_NUM, tableName.* FROM tableName) WHERE ROW_NUM BETWEEN 8000 AND 8050
表TABLENAME按ORDERBYFIELD建立索引, select /*+ first_row */ fields from TABLENAME where rowid in (select rid from (select rownum rno, rid from (select rowid rid from TABLENAME order by ORDERBYFIELD desc) where rownum <= 800000 ) where rno >= 799981);
FROM (SELECT ROWNUM ROW_NUM, tableName.* FROM tableName)
WHERE ROW_NUM BETWEEN 8000 AND 8050
select /*+ first_row */ fields
from TABLENAME
where rowid in (select rid from (select rownum rno, rid
from (select rowid rid from TABLENAME
order by ORDERBYFIELD desc)
where rownum <= 800000 )
where rno >= 799981);