월별 통계 카운트
SELECT SUM(DECODE(SUBSTR(NM_DATE,6,2),'01',1,0)) AS MON01,
SUM(DECODE(SUBSTR(NM_DATE,6,2),'02',1,0)) AS MON02,
SUM(DECODE(SUBSTR(NM_DATE,6,2),'03',1,0)) AS MON03,
SUM(DECODE(SUBSTR(NM_DATE,6,2),'04',1,0)) AS MON04,
SUM(DECODE(SUBSTR(NM_DATE,6,2),'05',1,0)) AS MON05,
SUM(DECODE(SUBSTR(NM_DATE,6,2),'06',1,0)) AS MON06,
SUM(DECODE(SUBSTR(NM_DATE,6,2),'07',1,0)) AS MON07,
SUM(DECODE(SUBSTR(NM_DATE,6,2),'08',1,0)) AS MON08
FROM GONGJI
WHERE NM_DATE BETWEEN '2009/01/01' AND '2012/08/31'
결과값ex)
mon01 mon02 mon03 mon04 mon05 mon06 mon07 mon08
8 10 15 10 6 19 13 13