My table in oracle database is like this:
Rollno | mark1 | Mark2 | mark3
--------+-----------+-----------+--------+
101 | 10 | 20 | 30
102 | 22 | 44 | 08
103 | 55 | 11 | 14
--------+-----------+-----------+--------+
And I want output like
Rollno | MAX(Mark1,mark2,mark3)
--------+-------------------------+
101 | 30
102 | 44
103 | 55
--------+-------------------------+
Any query suggestion?
Use
GREATEST
function