효율적인 쿼리작성법 - 월 단위 현황작성
1월달 ~ 12월달까지의 데이타를 한번 쿼리를 던져서 가져오는 방법 (연구중) Form 뒤의 테이블 부분을 서브쿼리를 이용하여 작성한다. Select substring(a.opendate, 7, 2) as tdate, sum(a.m1) as m1, sum(a.m2) as m2, sum(a.m3) as m3, sum(a.m4) as m4, sum(a.m5) as m5, sum(a.m6) as m6, sum(a.m7) as m7 , sum(a.m7) as m7, sum(a.m8) as m8, sum(a.m9) as m9, sum(a.m10) as m10, sum(a.m11) as m11, sum(a.m12) as m12 From ( Select opendate, t_target as m1, 0 as m2, ..
2008. 1. 25.
