34,838
社区成员




select sum(changeMoney) as 变动总额 ,
sum(case typeID when 1 then changeMoney else 0 end) as 下单,
sum(case typeID when 2 then changeMoney else 0 end) as 撤单,
sum(case typeID when 3 then changeMoney else 0 end) as 存款,
sum(case typeID when 4 then changeMoney else 0 end) as 取款,
sum(case typeID when 5 then changeMoney else 0 end) as 中奖,
sum(case typeID when 6 then changeMoney else 0 end) as 返点
--,sum(select count(addtime) from userInfo where addtime>'2010-1-8' and addtime<'2010-1-8')
from dbo.ChangeMoneyInfo ----这样也可以...