请教一个在sql语句中不做判断做除法保证不会出错的方法
请问以下这个语句有没有什么替换的方法能提高效率呢??
case when (a.Salecount1+a.Salecount2+a.Salecount3+a.Salecount4)<>0
then convert(decimal(9,2),
sum(b.Salecount1+b.Salecount2+b.Salecount3+b.Salecount4)
/sum(a.Salecount1+a.Salecount2+a.Salecount3+a.Salecount4))
else 0
end as Salecount