A Subquery that uses the ALL Keyword

Condition Equivalent expression

x > ALL (1, 2) x > 2

x < ALL (1, 2) x < 1

x = ALL (1, 2) (x = 1) AND (x = 2)

x <> ALL (1, 2) x NOT IN (1, 2)

WHERE Comparison field > ALL (Subquery)

The ALL Command looks something like this:

ALL Requires a set of results which is provided by the subquery

Here are some examples, let’s assume the Subquery returns the values 1 and 2