ORACLE分母为0的情况处理

描述：divisor is equal to zero”

处理方法：

# decode(分母,0,1,分母)

SELECT CELL_ID,
SUM(REGIST_ALL_NUM) REGIST_ALL_NUM,
SUM(REGIST_SUC_NUM) REGIST_SUC_NUM,
#解析: 当字段或字段的运算的值等于0时，该函数返回1，否则返回它本身
SUM(REGIST_SUC_NUM) / decode(SUM(REGIST_ALL_NUM),0,1,SUM(REGIST_ALL_NUM)) REGIST_SUC_RATE_NUM
FROM
DWS_XN_2021080420
GROUP BY CELL_ID