论坛 › SQL Server › sql server 三目运算符

hailai 发表于 2016-11-1 03:29:05

sql server 三目运算符

case when c.zsdecScore is null then 0 else c.zsdecScore end
select c.dutydeptname,c.dutydeptcode,c.stdscore, c.targettype,c.zsdecScore,(c.stdscore-(case when c.zsdecScore is null then 0 else c.zsdecScore end)
)/c.stdscore*100 asavg


应该是:

select   case   when   col <=0   then   0   else   col   end

查看完整版本: sql server 三目运算符