关于oracle数据库实现分页后的现实问题，如何从后几条记录开始显示？？？？？？在线等...

Question

select * from (
select rownum num,a.* from (select * from dcustmsg order by id_no desc) a where rownum <=5 )
where num>=1不知道满不满足你说的！！

Answer 1

select (trunc((rownum-1)/5)+1) kk,T.*
from HONGBO.ly_form T 
where rownum<25
order by (trunc((rownum-1)/5)+1) kk

Answer 2

SELECT
    *
FROM
    (SELECT * FROM HONGBO.ly_form ORDER BY ROWID desc)               
WHERE
    rowid not in (SELECT
                        rowid
                    FROM
                        (SELECT * FROM HONGBO.ly_form ORDER BY ROWID desc) 
                    WHERE
                        rownum<=("+(nowPage-1)*pageSize+")
                    ) AND
    rownum <="+pageSize+"
ORDER BY
    desc这样应该可以