Cummulative sum over rows

FAQ
1

Hi,

I want to cumulatively sum over rows of a table in SQL. Below are the initial and resulting tables. I tried to perform the operation as a SQL query and not through an interface, without success. I thank sincerely for any feedback.

Initial table
Column1 | Column2
1 | 1
1 | 1
1 | 1
1 | 1
1 | 1

Resulting table
Column1 | Column2
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5

2

Hi @brunolnetto
You should try looking in a forum dedicated to your database or stackoverflow.com - since it depends a lot on the database type, and really isn't specific to Metabase, but just general SQL.