How to do Running Total Formula in SQL Server

Question

How to do Running Total Formula in SQL

Give Example..

]1

Answer 1

DECLARE @T TABLE (
    [User] varchar(10),
    [Total] int
);
INSERT INTO @T([User], [Total]) VALUES
('A', 20), ('A', 40), ('B', 25), ('B', 25), ('C', 10), ('C', 10);

SELECT [User], [Total], SUM([Total]) OVER(PARTITION BY [User] ORDER BY [User]) AS RunningTotal
FROM @T;