SELECT
to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'yyyy') 工单单数,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'01',jh,0))) as 一月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'02',jh,0))) as 二月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'03',jh,0))) as 三月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'04',jh,0))) as 四月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'05',jh,0))) as 五月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'06',jh,0))) as 六月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'07',jh,0))) as 七月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'08',j
to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'yyyy') 工单单数,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'01',jh,0))) as 一月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'02',jh,0))) as 二月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'03',jh,0))) as 三月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'04',jh,0))) as 四月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'05',jh,0))) as 五月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'06',jh,0))) as 六月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'07',jh,0))) as 七月,
to_char(SUM(DECODE(to_char(to_date(YYYYMMDD,'yyyy-MM-dd'),'MM'),'08',j