ALL operator
- With ALL ,the predicate is TRUE, if every value selected by the sub-query satisfies the condition in the predicate of the outer query.
Find all customers whose ratings are higher than the ratings of every customers in "ahmd".
SELECT * FROM Customers WHERE rating > ALL (SELECT rating FROM Customers WHERE city='ahmd');