匯總求百分比出現除以零的錯誤,如何處理?
例如 表pa 字段pa01 字段pa02 字段p03
SELECT p03 sum(pa01),sum(pa02),
round(sum(pa01)/sum(pa01+pb02))
from pa
group by pa01 pa02
order p03
例如 表pa 字段pa01 字段pa02 字段p03
SELECT p03 sum(pa01),sum(pa02),
round(sum(pa01)/sum(pa01+pb02))
from pa
group by pa01 pa02
order p03
case when sum(pa01+pb02)=0 then 0 else round(sum(pa01)/sum(pa01+pb02)) end
from pa
group by pa01 pa02
order p03
sum(pa01),
sum(pa02),
case when sum(pa01+pb02) = 0 then 0
else round(sum(pa01)/sum(pa01+pb02),2)
end
from pa
group by pa01, pa02
round(case when sum(pa01+pb02)=0 then 0 else sum(pa01)/sum(pa01+pb02 end))