A Subquery that uses the ANY Keyword

Condition Equivalent expression

x > ANY (1, 2) x > 1

x < ANY (1, 2) x < 2

x = ANY (1, 2) x IN (1, 2)

x <> ANY (1, 2) (x <> 1) OR (x <> 2)

WHERE Comparison field > ANY (Subquery)

The ANY Command looks something like this:

ANY 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