Add column value to next column in SQL

Question

My sql table is

Week    Year    Applications
1       2017    0
2       2017    10
3       2017    20
4       2017    50
5       2017    0
1       2018    10
2       2018    0
3       2018    40
4       2018    50
5       2018    10

And I want SQL query which give below output

Week    Year    Applications
1       2017    0
2       2017    10
3       2017    30
4       2017    80
5       2017    80
1       2018    10
2       2018    10
3       2018    50
4       2018    100
5       2018    110

Can anyone help me to write below query?

Lukasz Szozda · Accepted Answer · 2018-05-31 10:35:37Z

2

You could use SUM() OVER to get cumulative sum:

SELECT *, SUM(Applications) OVER(PARTITION BY Year ORDER BY Week)
FROM tab

answered May 31, 2018 at 10:35

Lukasz Szozda

181k26 gold badges278 silver badges326 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Linoff · Accepted Answer · 2018-05-31 10:35:39Z

1

It looks like you want a cumulative sum:

select week, year,
       sum(applications) over (partition by year order by week) as cumulative_applications
from t;

answered May 31, 2018 at 10:35

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

Add column value to next column in SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related