业务需求:根据不同条件查询统计出总价钱
select
SUM(case when status=0 then price else 0 end) A,
SUM(case when status=5 then price else 0 end) B,
SUM(case when status=4 then price else 0 end) C,
SUM(case when status=1 then price else 0 end) D,
SUM(case when status=0 and addTime>=DateAdd(dd,-7,getdate()) then price else 0 end) E,
SUM(case when status=2 or status=3 then price else 0 end) F
from Device
效果图