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

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

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

Answers

database

Avinash Vajpayee

10y

928

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

Answers (3)

Next Recommended Forum

Here’s a closer look at both teams ahead of this vital Group

Databse New Table

Forum Statistics

Please welcome our newest member Muskan Verma.
3,095,507 users have contributed to 147,392 threads and 483,648
In the past 24 hours, we have 4 new threads, 15 new posts, and 72 new users.
In last week, the most popular thread is 'What do you understand by LLM Observability?'.

Upcoming Events

View all

The Cloud Show with Magnus Mårtensson ft. Mads Kempel Sørensen - Ep: 75
AI Agents Conference - 2025