이렇게 해보세요
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"