sum()分组后与原数据产生差异
有一个表大概2000万数据,表名mid_item_prd_201003, 现我对此表进行sum 分组,形成另外一个临时表mid_201003_tmp1
结果发现 两个表数据对不去来了,求高手解决 oracle 版本
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
create table mid_201003_tmp1 as
select prd_id,acct_item_id,serv_type_id,urban_id,cust_id,if_mer,
pay_id,area_id,sum(money) money
from mid_item_prd_201003
group by
prd_id,acct_item_id,serv_type_id,urban_id,cust_id,if_mer,pay_id,area_id;
select sum(money) from mid_201003_tmp1 ; --11734536460
select sum(money) from mid_item_prd_201003 ; --11731516135