初学者求一个求总和的sql语句

[吾邪]

假如现在有一张表（表a）简化如下

现在我要求编号相同的数量总和 就是显示以下的效果

请问sql语句肿么写

[reenjie]

select 编号,sum(数量) as 总和 from a group by a.编号

[andysun88]

select 编号, sum(编号) from a group by 编号

[發糞塗牆]

[向东流]

[卖水果的net]

建议，LZ 找本 SQL 基础的书看看！

[lakerskobemvp]

select 编号,sum(数量) as '总和'
from a
groupo by 编号

回答的最轻松的一次

[wanglei8]

select 编号, sum(数量)
from a
group by 编号

[天堂的鸽子]

select a.编号，sum（a.数量）as [总和] from a group by a.编号

[HelloWordGirl]

[「已注销」]

楼主应该应该是C++或者其他方向的

[woyoumeng]

楼主应该还没有毕业吧

[稻草_木偶]

送分题！！

[xiaxue77701]

select 编号,sum(数量) as 总和 from a group by 编号

[o0Jian0o]

引用
[code=sql]

[/code]select number ,SUM(zonghe) as '总和'
from a
group by number

[白开水太浓]

select  number ,SUM(zonghe) as '总和'
from a
group by number
--给点分吧

[o2_]

我都没来得及回答

[lufengsn]

复制粘贴代码，执行效果看看，望对你有用。

-- 创建表a
CREATE TABLE [dbo].[表a]
    (
      [No] [varchar](20) NOT NULL ,
      [Num] [int] NOT NULL
    )
GO

-- 添加测试数据
INSERT INTO [dbo].[表a](No, Num)
SELECT 'aa', 1 UNION
SELECT 'aa', 2 UNION
SELECT 'aa', 3 UNION
SELECT 'bb', 4 UNION
SELECT 'bb', 5
GO

-- 数量总和
SELECT No AS [编号],SUM(Num) AS [数量] FROM [dbo].[表a] GROUP BY No
GO

-- 删除表a
DROP TABLE [dbo].[表a]

[xiaodongni]

楼主 逗我们完吗？

[Neo_whl]

大家都抢答了

[翠花琳]