test2.txt
876 Bytes
select * from JWGL_FR_T_CH_REPORT_DATA1;
select * from JWGL_FR_T_CH_REPORT_DATA2;
-- sum part1
select
(
sum(lj_lj) + sum(xx_xxjg) + sum(xx_xxdg) + sum(zx_db) + sum(xx_xxcs) + sum(zx_tg) + sum(by_b1) +
sum(nvl(future_bx, 0)) + sum(xx_fdj) + sum(zx_lt) + sum(zx_rhy) + sum(zc_cbx) + sum(zc_db) + sum(zc_xzc) +
sum(zc_fdj) + sum(by_b2) + sum(by_b3) + sum(nvl(future_wx_db, 0)) + sum(nvl(future_wxfy, 0)) + sum(nvl(future_ktwx, 0)) + sum(nvl(future_sx, 0)) +
sum(nvl(future_dp, 0)) + sum(zx_zx) + sum(kt_bw) + sum(sg_sg)
) as part1
from JWGL_FR_T_CH_REPORT_DATA1
where
statdate >= to_date('20170301', 'YYYYMMDD')
and statdate <= to_date('20170331', 'YYYYMMDD')
-- sum part2
select
(
sum(zx_tg) + sum(jy) + sum(qt) + sum(zcfl) + sum(gj) + sum(sb) + sum(cjjf)
) as part2
from JWGL_FR_T_CH_REPORT_DATA2
where statdate = to_date('20170331', 'YYYYMMDD')