Hi, Is there any command as the "greatest" in MySQL that returns the maximum value in multiple columns?
Select * from ANIMALS
My expected return:
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)).
answered 12 Jan '15, 10:55