case when 用语更新表中:
update [dbo].[score]
set number=case when number >70 then number-10
when number>60 and number <=70 then number*1.5
when number <=60 then number * 0.8
else number end;
case when 用语查询语句时(当选取的参数可能会有多种情况时):
select SUM(case when PricePaid>0 then PricePaid else 0 end) from PayMent p where c.Id=p.CustomerId
and cast(p.PayDate as datetime) between ‘2019-04-13 16:35:31’ and ‘2019-05-07 10:16:40’