ANY

•    The ANY operator returns a boolean value that is TRUE if ANY of the subquery values meet the specified condition.
•    ANY means that the condition will be true if the operation is true for any of the values in the range.

 

          SELECT column_name(s)

          FROM table_name

          WHERE column_name operator ANY

             (SELECT column_name

             FROM table_name

             WHERE condition);