I have the following table:
x
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
Advertisement
Answer
You can do maths within a select statement, so the following will work:
SELECT column2 + column3 AS res FROM table