Hi, Is there any command as the "greatest" in MySQL that returns the maximum value in multiple columns? Select * from ANIMALS
My expected return:
Comment Text Removed
|
Please take a look at the GREATER function. It does what you want for two inputs only, so you may need to combine several of those - something like GREATER(GREATER(a,b),GREATER(c,d)). Replies hidden
Thanks a lot.
(12 Jan '15, 12:04)
LGregianin
|