窗口函数 SELECT - OVER Clause (Transact-SQL)
标签：scalar run into term blog start order rate with
窗口函数 SELECT - OVER Clause (Transact-SQL)
temp2
AS ( SELECT Id ,
[number] ,
ROW_NUMBER() OVER ( ORDER BY ( SELECT 1 )) AS SNO
FROM dbo.TestPartition )
SELECT temp2.Id ,
temp2.number ,
SUM(number) OVER ( PARTITION BY temp2.Id
ORDER BY temp2.SNO ) AS ‘number 累计值‘
FROM temp2