select 编号,sum(成本) as 总成本,sum(销售额) as 总销售额 from hhh group by 编号
select 编号,总成本=sum(成本),总销售额=sum(销售额) from tb group by 编号
select 编号, 总成本=sum(case when 编号=hhh.编号 then 成本 else 0 end), 总销售额=sum(case when 编号=hhh.编号 then 销售额 else 0 end) from hhh group by 编号
用group by 对编号进行分组就行: select 编号,sum(成本) as 总成本,sum(销售额) as 总销售额 from hhh group by 编号
select 编号 , 名称 , sum(成本) as 总成本, sum(销售额) as 总销售额 from hhh group by 编号, 名称
NinGoo(宁哥)没关系,分一样多!
declare @Temp Table(编号 varchar(50),名称 varchar(50),成本 money,销售额 money) insert into @Temp values ('001','1111',1.00,1.5) insert into @Temp values ('002','2222',2.00,2.5) insert into @Temp values ('003','3333',3.00,3.5) insert into @Temp values ('001','1111',1.00,1.5) insert into @Temp values ('001','1111',1.00,1.5) insert into @Temp values ('002','2222',2.00,2.5) insert into @Temp values ('001','1111',1.00,1.5) insert into @Temp values ('003','3333',3.00,3.5) select 编号,sum(成本) as 总成本,sum(销售额) as 总销售额 from @Temp group by 编号
from hhh
group by 编号
总成本=sum(case when 编号=hhh.编号 then 成本 else 0 end),
总销售额=sum(case when 编号=hhh.编号 then 销售额 else 0 end)
from hhh
group by 编号
select 编号,sum(成本) as 总成本,sum(销售额) as 总销售额 from hhh group by 编号
编号 ,
名称 ,
sum(成本) as 总成本,
sum(销售额) as 总销售额
from
hhh
group by
编号, 名称
insert into @Temp values ('001','1111',1.00,1.5)
insert into @Temp values ('002','2222',2.00,2.5)
insert into @Temp values ('003','3333',3.00,3.5)
insert into @Temp values ('001','1111',1.00,1.5)
insert into @Temp values ('001','1111',1.00,1.5)
insert into @Temp values ('002','2222',2.00,2.5)
insert into @Temp values ('001','1111',1.00,1.5)
insert into @Temp values ('003','3333',3.00,3.5)
select 编号,sum(成本) as 总成本,sum(销售额) as 总销售额 from @Temp group by 编号