String sql=String.format("select * from configuration where confid in(select confid from (select rownum rn,confid from(select confid from configuration order by confid desc)where rownum<= %s) where rn> %s) order by confid desc",size*pages, (pages-1)*size);
oracle 分页代码
最新推荐文章于 2024-10-02 10:51:38 发布