declare @t table 
(years int,trad_name varchar(8),plsa_revenue int)
insert into @t
select 2011,'纺织',4200 union all
select 2011,'纺织',4200 union all
select 2011,'纺织',4200 union all
select 2011,'金融',5000 union all
select 2011,'金融',5000 union all
select 2011,'金融',5000 union all
select 2011,'金融',5000 union all
select 2012,'日用化工',3000 union all
select 2012,'日用化工',3000 union all
select 2012,'日用化工',3000

select years ,trad_name,plsa_revenue=sum(plsa_revenue) from @t 
group by years ,trad_name
/*
years       trad_name plsa_revenue
----------- --------- ------------
2011        纺织        12600
2011        金融        20000
2012        日用化工      9000
*/

------解决方案--------------------

SQL code

create table t1(years int,trad_name varchar(10),plsa_revenue int)
insert  t1
select 2011, '纺织', 4200 union all
select 2011, '纺织', 4200 union all
select 2011, '纺织', 4200 union all
select 2011, '金融', 5000 union all
select 2011, '金融', 5000 union all
select 2011, '金融', 5000 union all
select 2011, '金融', 5000 union all
select 2012, '日用化工', 3000 union all
select 2012, '日用化工', 3000 union all
select 2012, '日用化工', 3000
go
select years,trad_name,SUM(plsa_revenue) as plsa_revenue from t1
group by years,trad_name 
/*
years tra_name   plsa_revenue
----   ------   -----------
2011    纺织    12600
2011    金融    20000
2012    日用化工    9000
*/
go
drop table t1