This will give the least number.
Syntax: least (value1, value2,
value3 … valuen)
Ex:
SQL> select least(1, 2, 3), least(-1, -2, -3) from dual;
LEAST(1,2,3) LEAST(-1,-2,-3)
-------------------- -----------------------
1 -3
Ø If all the
values are zeros then it will display zero.
Ø If all the
parameters are nulls then it will display nothing.
Ø If any of the
parameters is null it will display nothing.
