LoveUnix » ORACLE等数据库 » 被零除错误
2005-7-6 15:39
hguhgu
在SQL语句中统计中有类似sum(...)/sum(...)之类，如果分母为零会出错，请问如何避免出错？理想情况是分母为零的话结果也是零
2005-7-7 13:47
hguhgu
找到了：select decode(sum(field2),0,null,sum(field1)/sum(field2)) as value
页: [1]
查看完整版本: 被零除错误
Powered by Discuz! Archiver 5.5.0 © 2001-2006 Comsenz Inc.