월별, 년별 통계 내는 법

출처 : http://database.sarang.net/?inc=read&aid=22266&criteria=oracle&subcrit=&id=&limit=20&keyword=%BF%F9%BA%B0+%B1%D7%B7%EC&page=1


월별통계

select substr(visit_day,1,7) aS visit_yyyymm, gubun, sum(visit_num)

  from tab1

group by substr(visit_day,1,7), gubun

order by GUBUN,substr(visit_day,1,7)

년별통계

select substr(visit_day,1,4) as visit_yyyy, gubun, sum(visit_num)

  from tab1

group by substr(visit_day,1,4), gubun

order by GUBUN,substr(visit_day,1,4)