•    The ALL operator returns a boolean value, specifically TRUE if ALL of the subquery values meet the specified condition, and is used in conjunction with SELECT, WHERE, and HAVING statements.
•    ALL means that the condition will be true only if the operation is true for all values in the range.

          SELECT column_name(s)

          FROM table_name

          WHERE column_name operator ALL

             (SELECT column_name

             FROM table_name

             WHERE condition);