SELECT MIN(NSRSBH)
INTO START_WSPZH
FROM (SELECT NSRSBH
FROM (SELECT TT1.NSRSBH, ROWNUM ROWNO
FROM (SELECT T.NSRSBH
FROM WORK_INFO_MAIN M, WORK_INFO_CHILD T, DJ_NSRXX D
WHERE M.SERIAL_NO = T.SERIAL_NO
AND T.NSRSBH = D.NSRSBH
AND T.YXZT_DM = '3'
AND (T.LSSJ = 0 OR T.LSSJ IS NULL)
AND D.CGS_FLAG = 1
AND M.CZRY_DM = C_USER.USER_ID
ORDER BY TJRQ
) TT1)
WHERE ROWNO BETWEEN START_NUM AND END_NUM);
---语句二
SELECT MAX(NSRSBH)
INTO END_WSPZH
FROM (SELECT NSRSBH
FROM (SELECT TT1.NSRSBH, ROWNUM ROWNO
FROM (SELECT T.NSRSBH
FROM WORK_INFO_MAIN M, WORK_INFO_CHILD T, DJ_NSRXX D
WHERE M.SERIAL_NO = T.SERIAL_NO
AND T.NSRSBH = D.NSRSBH
AND T.YXZT_DM = '3'
AND (T.LSSJ = 0 OR T.LSSJ IS NULL)
AND D.CGS_FLAG = 1
AND M.CZRY_DM = C_USER.USER_ID
ORDER BY TJRQ
) TT1)
WHERE ROWNO BETWEEN START_NUM AND END_NUM);
