Oracle数据库SQL总结(二)

Sql代码
SELECT B.*, RN
FROM (SELECT A.*, ROWNUM AS RN2
FROM (SELECT XXKC.WID,
...
ROWNUM AS RN
FROM T_PY_XXKC XXKC
LEFT JOIN T_PY_KC KC ON KC.KCDM = XXKC.XXKCDM
ORDER BY XXKC.XXKCDM) A) B
WHERE B.RN2 > v_start
AND B.RN2 <= (((v_start/10) + 1) * v_limit )

SELECT B.*, RN
FROM (SELECT A.*, ROWNUM AS RN2
FROM (SELECT XXKC.WID,
...
ROWNUM AS RN