mmsql case when 的使用

select CustomerId
,Amount = SUM(Amount)
,InterestAmount = SUM(case when OpType = 1 then Amount else 0 end)
,PrincipalAmount = SUM( case when OpType = 2 then Amount else 0 end)
,TotalCount = Count(0)
from

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/feifeikui/p/4661669.html