34,576
社区成员
发帖
与我相关
我的任务
分享
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([name] nvarchar(22),[月份] int,[产量] int)
Insert #T
select N'张三',1,10 union all
select N'张三',1,30 union all
select N'张三',2,10 union all
select N'张三',3,50 union all
select N'张三',3,80 union all
select N'李四',1,100
Go
--测试数据结束
SELECT
name,
月份,
SUM(产量) AS 产量
FROM
#T
WHERE
name = '张三'
GROUP BY
name,
月份;
USE tempdb
GO
IF OBJECT_ID('t') IS NOT NULL DROP TABLE t
GO
CREATE TABLE t(
[name] NVARCHAR(10),
[m] INT,
cnt INT
)
SET NOCOUNT ON
INSERT INTO t
SELECT '张三',1,10
UNION ALL SELECT '张三',1,30
UNION ALL SELECT '张三',2,10
UNION ALL SELECT '张三',3,50
UNION ALL SELECT '张三',3,80
UNION ALL SELECT '李四',1,100
GO
SELECT [name] AS [姓名]
,m AS [月分]
,SUM(cnt) AS [产量]
FROM t
WHERE [name]=N'张三'
GROUP BY [name],m
/*
姓名 月分 产量
---------- ----------- -----------
张三 1 40
张三 2 10
张三 3 130
*/