Hi,
Try this...
DECLARE @TblVariable Table
(
col1 INT,
col2 INT
);
INSERT INTO @TblVariable VALUES
(1,20),
(2,10),
(1,10),
(2,5),
(1,20),
(3,10);
With tblCTE as
(
Select Row_Number() OVER (Order by col1) as RowNumber,col1,col2 from @TblVariable
)
SELECT Col1,Col2,
( SELECT SUM(Col2) FROM tblCTE T2 WHERE T2.RowNumber <= T1.RowNumber
AND T1.Col1 = T2.Col1 GROUP BY Col1
) AS Col3 FROM tblCTE T1 GROUP BY Col1,Col2,RowNumber
ORDER BY Col1, RowNumber
Thank you..