求SQL句.
A B C 字段

S1 20 1
S1 10 1
S2 30 1
S3 50 2

要得到查的果是
S1 30 1
S2 30 1
S3 50 2



[解决办法]
select A,sum(B) as B,max(C) as C from 表 group by A

[解决办法]
--直接分组即可

select A,sum(B) as B,C from 表 group by A,C
[解决办法]
select A,sum(B) as B,C from tab group by A,C order by A,C
[解决办法]
select A,sum(B) as B,C from 表 group by A,C

[解决办法]
Select A,sum(B) B,C from 表名
group by A,C

[解决办法]

select a,sum(b) as b ,c from tbl
group by a,c