select sum(case when r001>0 then r001-r004-r007 else 0 end)/SUM(case when R001 >0 then R001 else 0 end) from ENT_BASE group by HYDL_DM
要解决除零错误
...全文
713打赏收藏
sql语句除零错误
要求如果sum(r001)不为0,则计算sum(r001-r004-r007)/sum(r001)并且按照hydl分组查询 select sum(case when r001>0 then r001-r004-r007 else 0 end)/SUM(case when R001 >0 then R001 else 0 end) from ENT_BASE group by HYDL_DM 要解决除零错误