这样的查询语句让我伤脑筋？只得向各位请教了，救命啊！！！！

[licher]

现有这样的查询语句：
select ID, Sum(Degree)/Sum(Weight) as dw from DegreeTable
group by ID.

但是，如果Sum(Weight)为零的话，我想执行下面的语句，因为除数不允许为零。
select ID, Sum(Degree) from DegreeTable group by ID.

怎么把两个语句合成一个SQL语句啊？

[zjcxc]

select ID,case Sum(Weight) when 0 then Sum(Degree) else Sum(Degree)/Sum(Weight) end as dw from DegreeTable
group by ID

• 打赏
• 举报

回复 赞

[outwindows]

select ID,
Sum(Degree)/( case when Sum(Weight)=0 then 1 else Sum(Weight) end ) as dw
from DegreeTable
group by ID.

• 打赏
• 举报

回复 赞

[csdnwhycn]

同意楼上

• 打赏
• 举报

回复 赞

[licher]

我先试试。等下结分。

• 打赏
• 举报

回复 赞