sql数据查询

[IT~搬运工]

有个表数据是这样的
a b c
1 0 2
1 1 3
2 0 1
2 3 1
3 9 1

结果:
a b c
1 1 5
2 3 2
3 9 1

请问语句怎么写

[gw6328]

SELECT a,SUM(b) AS b,SUM(c) AS c FROM [表] GROUP BY a

[二月十六]

--测试数据
if not object_id(N'Tempdb..#T') is null
	drop table #T
Go
Create table #T([a] int,[b] int,[c] int)
Insert #T
select 1,0,2 union all
select 1,1,3 union all
select 2,0,1 union all
select 2,3,1 union all
select 3,9,1
Go
--测试数据结束
SELECT  a ,
        SUM(b) AS b ,
        SUM(c) AS c
FROM    #T
GROUP BY a