Search

LEAST



    This will give the least string.

    Syntax: greatest (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.