String.format("SELECT * FROM (SELECT ROWNUM RN,T.* FROM (%s) T WHERE ROWNUM<=%d) WHERE RN>=%d", sql, rowTo, rowFrom);
oracle 多功能分页
最新推荐文章于 2021-04-10 17:52:04 发布
String.format("SELECT * FROM (SELECT ROWNUM RN,T.* FROM (%s) T WHERE ROWNUM<=%d) WHERE RN>=%d", sql, rowTo, rowFrom);