select greatest( 1, 5, 10 ) : greatest « Numeric Math Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. greatest

select greatest( 1, 5, 10 )

   
SQL>
SQL> select greatest( 1, 5, 10 )
  2  from dual;
GREATEST(1,5,10)
----------------
              10

1 row selected.

SQL>
SQL> --








Related examples in the same category

1.GREATEST() returns the greatest of the list of expressions.
2.select greatest( 'A', 'a' )from dual;
3.select greatest( 'ONE', 1 )
4.GREATEST(12*6,148/2,73) LEAST(12*6,148/2,73)
5.This script demonstrates the Greatest functions