--rownum是一个伪列
SELECT * FROM
(
SELECT A.*
FROM (SELECT org_id,ROWNUM RN FROM base_org) A
WHERE RN >= 314370
)
WHERE RN <= 314378
oracle rownum
最新推荐文章于 2024-04-30 23:37:55 发布
--rownum是一个伪列
SELECT * FROM
(
SELECT A.*
FROM (SELECT org_id,ROWNUM RN FROM base_org) A
WHERE RN >= 314370
)
WHERE RN <= 314378