Oracle : select maximum value from different columns of the same row
Given this test data … SQL> select * 2 from your_table 3 / NAME M1 M2 M3 M4 —- ———- ———- ———- ———- A 1 2 3 4 B 6 3 4 5 C 1 5 2 1 SQL> … a straightforward GREATEST() call will give the desired result: SQL> select name 2 , greatest(m1, … Read more