년도별 통계 카운드
년도별 통계 카운드 SELECT YYYY, SUM(MON01) MON1, SUM(MON02) MON2, SUM(MON03) MON3, SUM(MON04) MON4, SUM(MON05) MON5, SUM(MON06) MON6, SUM(MON07) MON7, SUM(MON08) MON8 FROM ( SELECT SUBSTR(NM_DATE,1,4) as yyyy, DECODE(SUBSTR(NM_DATE,6,2),'01',1,0) AS MON01, DECODE(SUBSTR(NM_DATE,6,2),'02',1,0) AS MON02, DECODE(SUBSTR(NM_DATE,6,2),'03',1,0) AS MON03, DECODE(SUBSTR(NM_DATE,6,2),'04',1,0) AS MON04, DECODE(S..
더보기
월별 통계 카운트
월별 통계 카운트 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..
더보기