SELECT *
FROM (
SELECT a.*, ROWNUM rn
FROM (
select * from table
) a WHERE ROWNUM <= 40)
WHERE rn >= 21
oracle数据库分页查询数据的sql
最新推荐文章于 2024-06-27 10:58:53 发布
SELECT *
FROM (
SELECT a.*, ROWNUM rn
FROM (
select * from table
) a WHERE ROWNUM <= 40)
WHERE rn >= 21