报表 按照12个月汇总月汇总数和年汇总数

SELECT v.pk_org,v.name,SUM(A) "A",SUM(B) "B",SUM(C) "C",SUM(D) "D",SUM(E) "E",SUM(F) "F",SUM(G) "G",SUM(H) "H",SUM(I) "I",SUM(J) "J",SUM(K) "K",SUM(L) "L",SUM(SUM) FROM  (SELECT e.pk_org,o.name,
      DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),1,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "A",
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),2,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "B", 
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),3,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "C" ,
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),4,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "D", 
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),5,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "E" ,
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),6,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "F" ,
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),7,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "G" ,
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),8,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "H" ,
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),9,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "I" ,
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),10,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "J",
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),11,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "K" ,
			DECODE(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),12,(COUNT(EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')))),0) "L" ,
			COUNT(1) "SUM"
FROM  emm_repair_plan e , org_orgs o
WHERE e.pk_org=o.pk_org AND  e.dr=0  AND EXTRACT(YEAR FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')) = '2019'  GROUP BY 
EXTRACT(MONTH FROM to_date(e.billmaketime,'yyyy-mm-dd hh24:mi:ss')),e.pk_org,o.name) V GROUP BY v.pk_org,v.name;

https://www.cnblogs.com/lidj/p/5482389.html