这条语句咋写（在线）

[wxb1224]

我的语句是在access能够执行
SELECT Sum(Total)/iif(Sum(Number)=0,1,Sum(Number)) from tb
但在sqlserver中不能执行
我应该咋写

[lsxaa]

SELECT Sum(Total)/(case when Sum(Number)=0 then 1 else Sum(Number) end) from tb

[WangZWang]

select case Sum(Number) when 0 then 1
else Sum(Total)/Sum(Number)
from tb

[WangZWang]

select case Sum(Number) when 0 then 1
else Sum(Total)/Sum(Number) end
from tb

[davorsuker39]

SELECT Sum(Total)/Sum(Number) from tb
where Sum(Number) in (0,1,Sum(Number))

[davorsuker39]

SELECT Sum(Total)/(Sum(Number)=(case when Sum(Number)=0 then 1 else Sum(Number) end)) from tb