Extremal query

An extremal query returns the extremes, the minima and maxima.

SELECT FirstName, LastName FROM EMPLOYEE
WHERE Age = MAX(SELECT Age FROM EMPLOYEE) ;

This query returns the name of the oldest employee.