Select the sum of the column with the highest value in the achievement row

Question

I have this table:

a   b
-----
1   3
4   3
2   1

From where I would like to select the sum of whichever value is higher between a and b.

I tried with the following query, but it SUM()

doesn't recognize the value that I want to calculate it.

SELECT IF(a > b, a, b) AS number, SUM(number) FROM table;

+3

cedivad 18 oct. '14 at 9:41

2 answers

You can try like this IF ():

SELECT SUM( IF( a > b, a, b ) ) FROM test

or case

SELECT SUM(CASE WHEN a > b THEN a ELSE b END) FROM test

+1

Suresh Kamrushi 18 oct. 14 at 9:53

Milen · Accepted Answer · 2014-10-18T09:45:46+0000

What about case

SELECT SUM(CASE WHEN a > b THEN a ELSE b END)
FROM table