求SQL語句.ABC字段S1201S1101S2301S3502要得到查詢的結果是S1301S2301S3502[解决办法]select A,sum(B) as
求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