MAX

The Oracle and PL/SQL MAX function returns the maximum value of an expression.

The general format is:

MAX([DISTINCT | ALL] n)

Example 1:

SELECT MAX(price) FROM INVOICE;

returns:

231