如下语句能实现吗:
select
name,
(case when sum(counter1)=0 then 100 else sum(counter2)/sum(counter)1 end) as e1
from table1
group by name
即,判断分母为0,则返回100,否则返回表达式得到的值
在不用合计的时候可以实现,但是用上合计就不行了,请大家帮忙看看,是否语句有错,或者有没有类似的函数可以实现,谢了!
更正:
select
name,
(case when sum(counter1)=0 then 100 else sum(counter2)/sum(counter1) end) as e1
from table1
group by name