What does the ALL operator do in: salary > ALL (SELECT salary FROM managers)?

SQL Fundamentals Hard

SQL Fundamentals — Hard

What does the ALL operator do in: salary > ALL (SELECT salary FROM managers)?

Key points

  • The ALL operator compares the main query value to every value in the subquery
  • It requires the main query value to be greater than all values in the subquery
  • This is different from the ANY operator, which only requires the main query value to be greater than at least one value in the subquery

Ready to go further?

Start full exam Practice more questions

Related questions