create table A (款号 varchar(80) , 数量 int ) insert into A values ('6112334',1)insert into A values ('6112334',3)insert into A values ('6112355',1)insert into A values ('6112355',6)insert into A values ('6112355',7)SELECT 款号,SUM(数量) AS 数量 FROM A GROUP BY 款号 款号 数量 --------------------------------------------- ----------- 6112334 4 6112355 14(2 行受影响)
SELECT 款号,SUM(数量) AS 数量 FROM 表 GROUP BY 款号
create table A (款号 varchar(80) , 数量 int ) insert into A values ('6112334',1)insert into A values ('6112334',3)insert into A values ('6112355',1)insert into A values ('6112355',6)insert into A values ('6112355',7)SELECT 款号,SUM(数量) AS 数量 FROM A GROUP BY 款号 款号 数量 6112334 4 6112355 14
款号 数量
--------------------------------------------- -----------
6112334 4
6112355 14(2 行受影响)
款号 数量
6112334 4
6112355 14