orcle 按年度 月度 汇总

select mcorhr,dtype,
sum(h01) as sums,

datepart(year,(select left(mdate,4)+'-'+substring(mdate,5,2)+'-'+right(mdate,2))) as y,
datepart(month,(select left(mdate,4)+'-'+substring(mdate,5,2)+'-'+right(mdate,2))) as m
from "EMSHIS"."CBPM"."CBPM_LINE_LIMIT"
where 0=0

group by mdate,mcorhr,dtype