Quote:The operators ANY and ALL are always used in combination with one of the comparison operators.
The general syntax of both operators is
column operator [ANY | ALL] query
Quote:The ANY operator evaluates to true if the result of an inner query contains at least one row that satisfies the comparison.
Quote:If we want to list the part number, part description, unit price, and item class for each part that has a unit price greater than the unit price of every part in item class AP. Use either the ALL or ANY operator in your query.
SELECT Part.PartNum, Part.Description, Part.Price, Part.Class
WHERE [Price]> ANY
(Select Price from Part Where