SQL Greatest

This will give the greatest string.

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

     Ex:

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

GREAT GREAT

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

    c         srinu

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

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