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à.