Query help -Sum current and ID

[Sammy145]

Hi guys,

Table structure
Groupid value
1 0.91
2 1.2
3 0.2
4 1.6
I need to sumamrize the table. Add new coloumn-Summarygroupvalue2

Groupid value Summarygroupvalue2
1 0.91 0.91+1.2
2 1.2 1.2+0.2
3 0.2 0.2+ 1.6
4 1.6 1.6

How can I acheive Summarygroupvalue2 by adding row by row based on next group id?

Any help appreciated.

 

[Sammy145]

Figured it out using subquery to next next row.