Intermediate
SQL
Q67 / 100
What does "ANY" / "SOME" do when used with a comparison operator and a subquery, e.g. "WHERE salary > ANY (subquery)"?
Correct! Well done.
Incorrect.
The correct answer is B) It returns true if salary is greater than at least one value returned by the subquery
B
Correct Answer
It returns true if salary is greater than at least one value returned by the subquery
Explanation
"> ANY (subquery)" is true if the comparison holds for at least one row returned by the subquery; "> ALL (subquery)" requires it to hold for every row.
Progress
67/100