34,837
社区成员




SELECT ROW_NUMBER() OVER(PARTITION BY 字段 order by 字段)
--测试数据
if not object_id(N'Tempdb..#T') is null
drop table #T
Go
Create table #T([单据] nvarchar(23),[物料] nvarchar(23),[数量] int)
Insert #T
select N'单据A',N'物料A',2 union all
select N'单据A',N'物料B',3 union all
select N'单据A',N'物料C',1 union all
select N'单据B',N'物料A',5 union all
select N'单据B',N'物料B',2
Go
--测试数据结束
SELECT * ,
SUM(数量)OVER(PARTITION BY 单据) AS 订单数量
FROM #T