What does the EXISTS operator do differently from IN when used in a subquery?

SQL Data Analyst Hard

SQL Data Analyst — Hard

What does the EXISTS operator do differently from IN when used in a subquery?

Key points

  • EXISTS stops scanning once a match is found
  • IN evaluates the entire subquery result set
  • Efficiency can be a factor in choosing between the two operators

Ready to go further?

Start full exam Practice more questions

Related questions