求购一条SQL语句!
比如有张销售表!
good_id good_name good_sp good_unti good_sl good_dj good_je
001 aaaa fsadf 只 2 2.5 5
002 bbbb asdfasf 只 10 3.5 35
001 aaaa fsadf 只 3 2.0 6
001 aaaa fsadf 只 -1 2.0 -2.0
对数据进行汇总
select * from good_id,good_name,good_sp,good_unit,sum(good_sl) as sum_goodsl,
sum(good_je) as sum_goodje,sum(good_je)/sum(good_sl) as sum_gooddj
group by good_id,good_name,good_sp,good_unit
不知这样的写法对不对
sum(good_je)/sum(good_sl) as sum_gooddj 这样写法不知对不对(算单价的平均值)
问题是:
没有出现负数的情况下该语句可以通过,有负数就出现错误提示:Divide by zero error encountered