SQL Least

This will give the least string.

    Syntax: least(strng1, string2, string3 … stringn)      

    Ex:

           SQL> select least('a', 'b', 'c'), least('satish','srinu','saketh') from dual;

LEAST LEAST

-------    -------

    a         saketh

Ø If all the parameters are nulls then it will display nothing.

Ø  If any of the parameters is null it will display nothing.