감사드립니다.
원문대로는 오류가 나서 다음과 같이 조회하니 원하는 값이 나옵니다.
잘하고 있는 것인지 검토 부탁드립니다.
2월같은 경우 말일을 따로 넣어주야하는등.....
select
jajaeitem
,sum(case when jdate between '01-JAN-2008' and '31-JAN-2008' then goods_su else 0 end) Mon01
,sum(case when jdate between '01-FEB-2008' and '28-FEB-2008' then goods_su else 0 end) Mon02
,sum(case when jdate between '01-MAR-2008' and '31-MAR-2008' then goods_su else 0 end) Mon03
.....
,sum(case when jdate between '01-MAR-2008' and '31-MAR-2008' then goods_su else 0 end) Mon12
from jajaedetail where S.SDATE>='01-JAN-2008' and S.SDATE<='31-DEC-2008'
group by jajaeitem
자이언츠월드 님이 쓰신 글 :
: 이렇게 해보세요
: select
: sum(case when substring(jdate from 1 for 7)="2008.01" then goods_su else 0 end) day01
: ,sum(case when substring(jdate from 1 for 7)="2008.02" then goods_su else 0 end) day02
: ,sum(case when substring(jdate from 1 for 7)="2008.03" then goods_su else 0 end) day03
: ,sum(case when substring(jdate from 1 for 7)="2008.04" then goods_su else 0 end) day04
: ,sum(case when substring(jdate from 1 for 7)="2008.05" then goods_su else 0 end) day05
: ,sum(case when substring(jdate from 1 for 7)="2008.06" then goods_su else 0 end) day06
: ,sum(case when substring(jdate from 1 for 7)="2008.07" then goods_su else 0 end) day07
: ,sum(case when substring(jdate from 1 for 7)="2008.08" then goods_su else 0 end) day08
: ,sum(case when substring(jdate from 1 for 7)="2008.09" then goods_su else 0 end) day09
: ,sum(case when substring(jdate from 1 for 7)="2008.10" then goods_su else 0 end) day10
: ,sum(case when substring(jdate from 1 for 7)="2008.11" then goods_su else 0 end) day11
: ,sum(case when substring(jdate from 1 for 7)="2008.12" then goods_su else 0 end) day12
: from jajaedetail where jdate>="2008.01.01" and jdate<="2008.12.31"
|