07/02/2013

Oracle get MAX or MIN between multiple values

In order to get the MAX or MIN between multiple values (NOT just numbers!) you can respectively use GREATEST or LEAST.

NOTE: beware! If one of the parameters you pass is NULL, then the function will return NULL!

No comments:

Post a Comment

With great power comes great responsibility.

Da grandi poteri derivano grandi responsabilità.