GREATEST() returns the greatest of the list of expressions. : greatest « Numeric Math Functions « Oracle PL / SQL






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

GREATEST() returns the greatest of the list of expressions.

   
SQL>
Syntax: GREATEST(<expression1>,<expression2>. . . <expression>)
SQL>
SQL> SELECT
  2     GREATEST('ALEX','WALTER','PHILLIP')   names,
  3     GREATEST(10,20,135)     numbers
  4  FROM dual;

NAMES     NUMBERS
------ ----------
WALTER        135

SQL>
SQL>
SQL>








Related examples in the same category

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