Running query in sql server

Question

Input: ID Value 1 10 2 20 3 30 4 40 5 50 Output: ID Value 1 10 2 30(10+20) 3 50(20+30) 4 70(30+40) 5 90(40+50) Please help me to here?

Sai Reddy · Answer

Thank you. Here i found an simple solution. With partition------ select *,sum(salary) over ( order by id )as runningsal from Employees Without partition------ select *,sum(salary) over (partition by gender order by id )as runningsal from Employees

Rajeev Punhani · Answer

Hi Sai, Please find the below query. SELECT t.ID, COALESCE ((t.Value+t1.Value),t.Value) as Value FROM Sample t left JOIN Sample t1 ON t.ID = t1.ID+1 order by t.ID;

Shahriar Nikkhah · Answer

try this https://www.codeproject.com/Articles/37468/Sum-of-previous-row-values-in-SqlServer

sudipta sanyal · Answer

DECLARE @TestTable TABLE ( ID INT , Value DECIMAL (18,2) ) INSERT INTO @TestTable (ID, Value) SELECT 1, 10 UNION ALL SELECT 2, 20 UNION ALL SELECT 3, 30 UNION ALL SELECT 4, 40 UNION ALL SELECT 5, 50 UNION ALL SELECT 6, 60 UNION ALL SELECT 7, 70 -- IF Using SELECT ID, Value, ( SELECT SUM (b.Value) FROM @TestTable b WHERE b.id AS 'total' FROM @TestTable a -- IF Using >= 2012 Sql Server SELECT ID, Value, SUM (Value) OVER ( ORDER BY id) AS 'total' FROM @TestTable

Navneet Arora · Answer

SELECT t2.id, t2.value, SUM (t2.value) OVER ( ORDER BY t2.id) as [Result] FROM Test01 t2 ORDER BY t2.id;

Amit Kumar · Answer

Hi, Please use the below query. SELECT ID ( SELECT SUM (ID) FROM EMPLOYEE employee WHERE tbl.ID AS 'RUNNING TOTAL Value' FROM tbl EMP And for more details same example use the below link. https://www.dotnettechpoint.com/2018/03/calculate-running-total-in-sql-serverr.html

Jayesh Vaghasiya · Answer

DECLARE @table AS TABLE (ID Int,Value int) INSERT INTO @table VALUES (1, 10),(2, 20),(3, 30),(4, 40),(5, 50) SELECT t.ID,isnull(t.Value,0) + isnull(t1.Value,0) as Value FROM @table t left JOIN @table t1 ON t.ID = t1.ID+1 SELECT t.ID,CONVERT(varchar(16),isnull(t.Value,0) + isnull(t1.Value,0)) + case when isnull(t1.Value,0) = 0 then '' else '(' + CONVERT(varchar(16),isnull(t1.Value,0)) + '+' + CONVERT(varchar(16),isnull(t.Value,0)) +')' end --as Value FROM @table t left JOIN @table t1 ON t.ID = t1.ID+1 --order by t.ID;

Jayesh Vaghasiya · Answer

DECLARE @table AS TABLE (ID Int,Value int) INSERT INTO @table VALUES (1, 10),(2, 20),(3, 30),(4, 40),(5, 50) SELECT t.ID,isnull(t.Value,0) + isnull(t1.Value,0) as Value FROM @table t left JOIN @table t1 ON t.ID = t1.ID+1