Tagged: MySQL

解决之后正常查询结果,只有2位! 0

MySQL SUM function results in solutions of up to 13 decimals!

浏览量: 3 sql statement: (SELECT SUM(O_G.GOODS_AMOUNT) as AMOUNT_SUM,SUM(o_g.goods_cost*o_g.goods_number) as cost_sum,sum(o_g.goods_number) as number_sum from ERP_ORDER_GOODS AS O_G left outer join erp_order as o on o_g.order_id = o.order_id left outer join erp_goods as g on g.gid...