sqlserver 逐行累加

CREATE TABLE [dbo].[User](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [Name] [nvarchar](20) NULL,

    [Score] [int] NULL）

-- 逐行累加

SELECT t2.A, SUM(t1.A)
FROM (SELECT Score a, ROW_NUMBER() OVER(ORDER BY Id) RK from [User]) t1,      (SELECT Score a, ROW_NUMBER() OVER(ORDER BY Id) RK from [User]) t2
WHERE t1.rk <= t2.rk
group by t2.a
ORDER BY T2.A