Usage and Example of SQL ALL Keyword

SQL Keyword Reference

ALL

If all subquery values meet the condition, the ALL command returns true.

If all records in the OrderDetails table have a quantity of10, then the following SQL statement returns TRUE and lists the product name:

　　SELECT ProductName
FROM Products
WHERE ProductID = ALL (SELECT ProductID FROM OrderDetails WHERE Quantity =　10);

SQL Keyword Reference