PL/SQL Min

Oracle PL/SQL Min Function

The Min function returns the minimum value of an expression.

The Min Function syntax:

Select min(exp ) From table Where condition;

Example 1:

Select min(e.sal) From emp e Where e.job='CLERK';

800

Example 2:

Select e.ename, e.sal
From emp e
Where e.sal = (Select Min(e1.sal) From emp e1);

Result:

Ename Sal
SMITH 800