Java codeSELECT '200902' DATE_ID,
T_COPLAN.MANAGECOM_ID MANAGECOM_ID,
SUM(T_COPLAN."VALUE") VALUE
FROM T_COPLAN T_COPLAN
WHERE T_COPLAN.DEPT_ID = 1
AND T_COPLAN.SUBJECT_ID = 1
AND length(T_COPLAN.DATE_ID) = 6
AND length(T_COPLAN.MANAGECOM_ID) = 4
AND( case
when substr('200902',5,2) in ('01','02','03') then
to_date(T_COPLAN.DATE_ID, 'yyyymm') BETWEEN
to_date(substr('200902', 1, 4) || '01', 'YYYYMM') AND
to_date('200902', 'YYYYMM')
when substr('200902',5,2) in ('04','05','06') then
to_date(T_COPLAN.DATE_ID, 'yyyymm') BETWEEN
to_date(substr('200902', 1, 4) || '04', 'YYYYMM') AND
to_date('200902', 'YYYYMM')
when substr('200902',5,2) in ('07','08','09') then
to_date(T_COPLAN.DATE_ID, 'yyyymm') BETWEEN
to_date(substr('200902', 1, 4) || '07', 'YYYYMM') AND
to_date('200902', 'YYYYMM')
when substr('200902',5,2) in ('10','11','12') then
to_date(T_COPLAN.DATE_ID, 'yyyymm') BETWEEN
to_date(substr('200902', 1, 4) || '10', 'YYYYMM') AND
to_date('200902', 'YYYYMM')
end
)
group by T_COPLAN.MANAGECOM_ID