Function to find greatest numeric value across different fields
In a row of data with multiple numeric fields, how can I easily find the greatest value using simple function like GREATEST(Attribute1, Attribute2) as for Oracle SQL?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 25, 2009 2:52 AM
UPDATED:
August 25, 2009 2:14 PM
Answer Wiki:
Your example is the answer. The GREATEST function does exactly that.
Try something like:
<pre>SELECT GREATEST(10,20,30,40,50) FROM dual;
SELECT GREATEST(1,-5) FROM dual;
SELECT GREATEST(field_x,field_y,field_z)
FROM your_table
WHERE some_field = 'X';</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
