PL/SQL Max

Oracle PL/SQL Max Function

The Max function returns the maximum value of an expression.

The Max Function syntax:

Select max(exp ) From table Where condition;

Example 1:

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

1300

Example 2:

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

Result:

EnameSal
KING5000