tk 님이 쓰신 글 :
: 정말모르겠네요 님이 쓰신 글 :
: : MS-SQL만 만지다가 firebird를 사용하게 되었습니다.
: :
: : firebird는 from절에 서브쿼리가 안들어 가던데... 당췌 쿼리문을 못 만들겠네요.. ㅜ.ㅜ;
: :
: : table1
: : --------------------------------
: : a              b              c              d
: : --------------------------------
: : 가             2             12             Y
: : 나             3             0              N
: : 다             6             2              N
: : 가            90             87            Y
: : 나            12              5             Y
: :
: : select a, sum(b), sum(c) from (
: :    select a, sum(b) as b, 0 as c from table1 where d='Y'
: :    group by a, d
: :    union all
: :    select a, 0 as b, sum(c) as c from table1 where d='N'
: :    group by a, d
: : ) z
: : group by a
: :
: : 이것좀 firebird 쿼리로 바꿔주세요...  부탁드립니다.
: :
: : 도와주세요~~~~
: select  a, sum( case d when 'Y' then  b else 0 end) ,
:                 sum( case d  when 'N' then c else 0 end)
: from table1 where d in ('Y','N')
: group by a