create table aa(名称 varchar(2),数量1 int,数量2 int) go insert into aa values('a',100,50) go insert into aa values('b',50,10) go insert into aa values('b',30,20) go insert into aa values('a',50,30) go insert into aa values('a',40,20) goselect 名称, sum(数量1)+sum(数量2) as 总数量 from aa group by 名称
select 名称,sum(数量1+数量2) as 总数量 from 数据表 group by 名称
go
insert into aa values('a',100,50)
go
insert into aa values('b',50,10)
go
insert into aa values('b',30,20)
go
insert into aa values('a',50,30)
go
insert into aa values('a',40,20)
goselect 名称, sum(数量1)+sum(数量2) as 总数量 from aa
group by 名称
group by 名称