Loading lesson path
operator is used to compare a value to every value returned by a subquery.
Formula
operator evaluates to TRUE if every value in the subquery result - set meet the condition.operator is typically used with WHERE and
statements.
column_name(s)
table_name
column_name operator ALL ( subquery
);The operator must be a standard comparison operator (=, <>, !=, >, >=, <, or <=).
"Products" table in the Northwind sample database:
18.00
19.00
10.00
22.00
"OrderDetails" table:
11 12
42 10
72
14
The following SQL returns the ProductName if ALL the records in the "OrderDetails" table has Quantity equal to 10. This will of course return FALSE
because the Quantity column has many different values (not only the value of 10):