CREATE TABLE [dbo].[User](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](20) NULL,
[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