Loading lesson path
Concept visual
Start at both ends
❮ SQL Keywords
command returns true if any of the subquery values meet the condition. The following SQL statement returns TRUE and lists the productnames if it finds ANY records in the OrderDetails table where quantity = 10:
WHERE ProductID = ANY (SELECT
ProductID FROM OrderDetails WHERE Quantity = 10);The following SQL statement returns TRUE and lists the productnames if it finds ANY records in the OrderDetails table where quantity > 99:
WHERE ProductID = ANY (SELECT ProductID
FROM OrderDetails WHERE Quantity > 99);❮ SQL Keywords