oracle中累计求和_怎么写求季度累计求和SQL语句

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