重复数据查询,值相加

数据表 语句 select name,sum(daikou1) as t1,sum(daikou2) as t2 from test1 group by na

数据表

语句

select name,sum(daikou1) as t1,sum(daikou2) as t2 from test1 group by name

结果