oracle 分页代码

            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);