database

Question

id value sum 1 10 10 2 20 30 3 30 60 4 40 100 5 50 150 initially we have two column id and value but we want result in which third column data come

Avinash Vajpayee · Answer

ok fine thanks

Manoj Bhoir · Answer

Hi Try this query : select a.Id a.value sum(b.value) as TableName from TableName a cross join TableName b where b.Id group by a.Id a.value Note : Replace TableName with your TableName

Vilas Shende · Answer

In SQL server DB the query can be wrote as shown below to get cumulative sum:- SELECT t1.id t1.value SUM(t2.value) AS SUM FROM t t1 INNER JOIN t t2 ON t1.id >= t2.id GROUP BY t1.id t1.value ORDER BY t1.id // the url can be refer