How can we find cumulative sum in SQL Server.
T-SQL
DECLARE @Table TABLE
(ID INT,Amount INT)
INSERT INTO @Table
SELECT 1, 200 UNION ALL
SELECT 2,,200 UNION ALL
SELECT 3, 100 UNION ALL
SELECT 4, 350 UNION ALL
SELECT 5, 100
SELECT T1.ID,T1.Amount,SUM(T2.Amount) AS 'Cum Sum'
FROM @Table T1 JOIN @Table T2 ON T2.ID <= T1.ID
GROUP BY T1.ID,T1.Amount
T-SQL
DECLARE @Table TABLE
(ID INT,Amount INT)
INSERT INTO @Table
SELECT 1, 200 UNION ALL
SELECT 2,,200 UNION ALL
SELECT 3, 100 UNION ALL
SELECT 4, 350 UNION ALL
SELECT 5, 100
SELECT T1.ID,T1.Amount,SUM(T2.Amount) AS 'Cum Sum'
FROM @Table T1 JOIN @Table T2 ON T2.ID <= T1.ID
GROUP BY T1.ID,T1.Amount
That’s It
Enjoy Learning.
No comments:
Post a Comment