General information
Category:
Coding, syntax & commands
Title:
SQL MAX(a,b,c,d) equivalent
I think I should know this but..........
I have a DB2 table with fields Num1, Num2, Num3 (among others)
I need to get the largest of the three numeric fields.
Clearly SELECT MAX(Num1, Num2, Num3) FROM mytable won't work, but it seems as if there ought to be some simple equivalent. I just haven't been able to find it.
Can somebody point me in the right direction?
Thanks.........Rich
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only