MIN

The Oracle and PL/SQL MIN function returns the minimun value of an expression.

The general format is:

MIN([DISTINCT | ALL] n)

Example 1:

SELECT MIN(price) FROM INVOICE;

returns:

1