SQL sum values in columns for each row

Question

I have the following table:

column1 | column2 | column3
  1        3          4
  5        7          6

how do I sum the values of say, column 2 and 3, to return the sum?

The expected result is:

res
7
13

If those columns are NULLable you probably want to apply COALESCE: coalesce(column2,0) + coalesce(column3,0) — dnoeth
– dnoeth, Commented Jul 20, 2020 at 9:54

Jim Wright · Accepted Answer · 2020-07-20 09:52:24Z

3

You can do maths within a select statement, so the following will work:

SELECT column2 + column3 AS res FROM table

answered Jul 20, 2020 at 9:52

Jim Wright

6,0681 gold badge18 silver badges35 bronze badges

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

Comments

Syed Mushtaq · Accepted Answer · 2020-07-20 10:02:29Z

1

This works in postgresql.

  select sum(col2+col3) from (
  select col1, col2,col3,row_number() over() as rows from column_sum )  as foo 
  group by rows order by rows;

answered Jul 20, 2020 at 10:02

Syed Mushtaq

3413 silver badges7 bronze badges

This is just a complicated way to express col2+col3 :-)