(
select t.*, rownum rn
from (select * from tablename) t
where rownum<=50
)
where rn>=31 -- 本SQL语句就实现了读取一个数据表的31-50之间的记录
转载于:https://www.cnblogs.com/leodrain/archive/2008/05/20/implement-pager-without-oracle-procedure.html
2022-05-27 13:04:37
转载于:https://www.cnblogs.com/leodrain/archive/2008/05/20/implement-pager-without-oracle-procedure.html