ORACLE的分页,不是直接改limit为Rownum就可以,
select *
from (select rn.*, rownum rownumno
from (
SELECT * FROM PrpDexch
) rn
where rownum < 35)
where rownumno > 29
select *
from (select rn.*, rownum rownumno
from (
SELECT * FROM PrpDexch
) rn
where rownum < 35)
where rownumno > 29
2016-11-01