SELECT x.* from (SELECT z.*,rownum numbers from(select * from tablename t order by t.id) z where rownum<maxNum) x where x.numbers>minNum;
Oracle 分页SQL
最新推荐文章于 2024-04-06 22:51:49 发布
SELECT x.* from (SELECT z.*,rownum numbers from(select * from tablename t order by t.id) z where rownum<maxNum) x where x.numbers>minNum;