select * from ( select rownum as row_no,row_table_bounded.* from ( SELECT kanri.s_no, kanri.s_kin, kanri.sclo_dt, kanri.impdue_dt, kanri.cb_sts, kanri.unckin_total, kanri.cbkin_total, kessai1.comsekrnm_knj, kessai1.comsek_tel, kessai1.comsektanto_knj FROM tmmkokyakukessai kessai2, tjnkzkaishukanri kanri, tmmkokyakukessai kessai1 WHERE kessai2.comkaiten_cod = '130285' AND kessai2.comtekiyostr_ymd <= 20100222 AND kessai2.comtekiyoend_ymd >= 20100222 AND kessai2.comunckyk_cod = '00' AND kanri.setkyk_cd = (kessai2.comkykichiran_cod || kessai2.comkeikyk_cod || kessai2.comsekkyk_cod) AND kanri.impdue_dt >= 20100123 AND kanri.impdue_dt <= 20100222 AND (SUBSTR(kanri.setkyk_cd,1,4) = kessai1.comkykichiran_cod AND SUBSTR(kanri.setkyk_cd,5,2) = kessai1.comkeikyk_cod AND SUBSTR(kanri.setkyk_cd,7,2) = kessai1.comsekkyk_cod) AND kessai1.comtekiyostr_ymd <= kanri.sclo_dt AND kessai1.comtekiyoend_ymd >= kanri.sclo_dt AND kessai1.comunckyk_cod = '00' AND kessai2.comkaitanto_cod = '0000006556' AND (kanri.cb_sts = 0 OR kanri.cb_sts = 1) ORDER BY kanri.impdue_dt, kessai1.comsekrnm_knj, kanri.s_no ) row_table_bounded ) where row_no between 1 and 3000
( SELECT kanri.s_no, kanri.s_kin, kanri.sclo_dt, kanri.impdue_dt,
kanri.cb_sts, kanri.unckin_total, kanri.cbkin_total, kessai1.comsekrnm_knj,
kessai1.comsek_tel, kessai1.comsektanto_knj
FROM tmmkokyakukessai kessai2, tjnkzkaishukanri kanri, tmmkokyakukessai kessai1
WHERE kessai2.comkaiten_cod = '130285'
AND kessai2.comtekiyostr_ymd <= 20100222
AND kessai2.comtekiyoend_ymd >= 20100222
AND kessai2.comunckyk_cod = '00'
AND kanri.setkyk_cd = (kessai2.comkykichiran_cod || kessai2.comkeikyk_cod || kessai2.comsekkyk_cod)
AND kanri.impdue_dt >= 20100123 AND kanri.impdue_dt <= 20100222
AND (SUBSTR(kanri.setkyk_cd,1,4) = kessai1.comkykichiran_cod
AND SUBSTR(kanri.setkyk_cd,5,2) = kessai1.comkeikyk_cod
AND SUBSTR(kanri.setkyk_cd,7,2) = kessai1.comsekkyk_cod)
AND kessai1.comtekiyostr_ymd <= kanri.sclo_dt AND kessai1.comtekiyoend_ymd >= kanri.sclo_dt
AND kessai1.comunckyk_cod = '00' AND kessai2.comkaitanto_cod = '0000006556'
AND (kanri.cb_sts = 0 OR kanri.cb_sts = 1)
ORDER BY kanri.impdue_dt, kessai1.comsekrnm_knj, kanri.s_no ) row_table_bounded ) where row_no between 1 and 3000
desc 三个表,看看表结构