SUM SQL Function For Columns

Question

I have a sql query that is outputting:

col1    col2
A        1
B        3
C        4
D        5

Is there a way to add a column where it outputs the sum of all the numbers in col2?

col1    col2  col3
A        1     13
B        3     13
C        4     13
D        5     13

Gordon Linoff · Accepted Answer · 2020-07-15 14:43:51Z

1

You can use window functions:

select col1, col2, sum(col2) over () as col3
from t;

answered Jul 15, 2020 at 14:43

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

1 Answer 1