Function to find greatest numeric value across different fields
Home > IT Answers > SQL Server > Function to find greatest numeric value acros...
Kevling
5 pts.
0
Q:
Function to find greatest numeric value across different fields
WINSQL Numeric Function, WinSQL, Oracle SQL
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?
ASKED: Aug 25 2009  2:52 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29820 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Your example is the answer. The GREATEST function does exactly that.

Try something like:

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';
Last Answered: Aug 25 2009  2:14 PM GMT by Carlosdl   29820 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0