The ALL command returns true if all values in the subquery meet the condition.
The subsequent SQL statement returns TRUE and lists the product names if every record in the OrderDetails table has a quantity of 10.
| SELECT ProductName FROM Products WHERE ProductID = ALL (SELECT ProductID FROM OrderDetails WHERE Quantity = 10); |