December 1, 2011

Find cumulative sum In SQL

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

That’s It
Enjoy Learning.

No comments:

Post a Comment