28,391
社区成员
发帖
与我相关
我的任务
分享
select jsy, sum(grgl) from
(
select jsy, grgl from sell
union all
select jsy1 as jsy, grgl as grgl from sell
) a
group by jsy
order by jsy
create table sell(id int,chehao int,jsy nvarchar(10),grgl int,tc int,jsy1 nvarchar(10),grgl1 int,tc1 int)
insert into sell select 1,2007,'方衍专',50,30,'张远恒',20,30
insert into sell select 2,2008,'张远恒',10,20,'方衍专',25,70
insert into sell select 3,2009,'方衍专',20,35,'张远恒',25,37
insert into sell select 4,2010,'张三',5,17,'李四',18,21
insert into sell select 5,2011,'小三',8,7,'小四',8,1
select jsy,sum(grgl) as grgl from(
select jsy,grgl from sell
union all
select jsy1 as jsy,grgl1 as grgl from sell
)T group by jsy
go
drop table sell
/*
jsy grgl
---------- -----------
方衍专 95
李四 18
小三 8
小四 8
张三 5
张远恒 55
(6 行受影响)
*/