高難度SQL查詢語句--ACCESS數據庫(50分)

Y

ygj9712

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-27

• #1

A1 A2 A3
D0001 50 in
D0002 30 out
D0001 40 in
D0003 50 in
D0001 30 out
D0003 70 in
D0002 80 in
用一條SQL語句對a1分組查詢出A3字段條件為in的總和
減去A3字段條件為out的總和,各位幫幫忙,好急呀!

 

K

kk2000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-27

• #2

select A1, sum(case A3 when 'in' then A2 else 0 end) + sum(case A3 when 'out' then -A2 else 0 end) Total from Tb group by A1/
ACCESS數據庫 完了！ 不懂

 

轻

轻舞肥羊

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-27

• #3

SELECT a1, sum(iif(a3='in',a2,0))-sum(iif(a3='out',a2,0))
FROM tab
GROUP BY a1;

 

C

chen_liang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-27

• #4

同意轻舞肥羊，access中用iif代替case