오기주 wrote:

> 계산 항목을 가로로 나오게 할수 없는지요??

> 조건을 개별적으로 줄수 있는 방법이 없을까요??

>



이런 경우는 DB에 따라 문법이 다릅니다.



Select Sname,

SQL 이라면

어음 = sum(Case when Chek = '어음' then Mony else 0 end),

현금 = sum(Case when Chek = '현금' then Mony else 0 end),

당좌 = sum(Case when Chek = '당좌' then Mony else 0 end),

가계 = sum(Case when Chek = '가계' then Mony else 0 end)

Oracle 이라면

sum(decode(Chek, '현금', Mony, 0)) 현금

sum(decode(Chek, '어음', Mony, 0)) 어음

sum(decode(Chek, '당좌', Mony, 0)) 당좌

sum(decode(Chek, '가계', Mony, 0)) 가계

From Dbname

Where cDate between '1998-08-01' and '1998-08-13'

Group By Sname



그것도 아니면...



Select a.Sname, b.현금, c.어음, d.가계, e.당좌

From Dbname a,

(select Sname, Sum(Mony) from Dbname where Chek = '현금'

cDate between '1998-08-01' and '1998-08-13' Group By Sname) b,

(select Sname, Sum(Mony) from Dbname where Chek = '어음'

cDate between '1998-08-01' and '1998-08-13' Group By Sname) c,

(select Sname, Sum(Mony) from Dbname where Chek = '가계'

cDate between '1998-08-01' and '1998-08-13' Group By Sname) d,

(select Sname, Sum(Mony) from Dbname where Chek = '당좌'

cDate between '1998-08-01' and '1998-08-13' Group By Sname) e

where

(a.Sname = b.Sname)

and (a.Sname = c.Sname)

and (a.Sname = d.Sname)

and (a.Sname = e.Sname)



조건을 개별적으로 주는 가장 기본적인 방법은 아마 SubQuery가 아닐까합니다..