Oracle数据库SQL总结(3)

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