今天遇到的一个问题,
表结构:
optionID int identity(1,1) constraint o_pk primary key
account int ,
option char(1) check(option='d' or option='w' ) //w为取款 D为存款
quantity money
optionID option account quantity
1 d 2012 100
2 w 2013 200
1 w 2012 50
问题:统计各帐号的余额.
select account ,sum(
case quantity
when option='d' then quantity,
when option='w' then o-quantity
) as Balance
from accounttable
group by account