SELECT SUM(CASE WHEN name ='废气' THEN VALUE ELSE 0 END)AS 废气, SUM(CASE WHEN name ='废水' THEN VALUE ELSE 0 END)AS 废水FROM TB
select sum(case when name = '废气' then value else 0 end), sum(case when name = '废水' then value else 0 end) from ta
create table #TT ( ID int, name varchar(50), value decimal(19,2) ) insert into #TT select 2001,'废气',0.5 insert into #TT select 2001,'废水',1.0 insert into #TT select 2002,'废气',3.0 insert into #TT select 2003,'废气',2.0 insert into #TT select 2004,'废水',4.0select sum(case when name = '废气' then value else 0 end) '废气', sum(case when name = '废水' then value else 0 end) '废水' from #TT 废气 废水 --------------------------------------- --------------------------------------- 5.50 5.00(1 行受影响)
SUM(CASE WHEN name ='废气' THEN VALUE ELSE 0 END)AS 废气,
SUM(CASE WHEN name ='废水' THEN VALUE ELSE 0 END)AS 废水FROM TB
sum(case when name = '废水' then value else 0 end)
from ta
(
ID int,
name varchar(50),
value decimal(19,2)
)
insert into #TT select 2001,'废气',0.5
insert into #TT select 2001,'废水',1.0
insert into #TT select 2002,'废气',3.0
insert into #TT select 2003,'废气',2.0
insert into #TT select 2004,'废水',4.0select sum(case when name = '废气' then value else 0 end) '废气',
sum(case when name = '废水' then value else 0 end) '废水'
from #TT
废气 废水
--------------------------------------- ---------------------------------------
5.50 5.00(1 行受影响)