Multiple choice

Which SQL operator is used to test whether the sub query or inner query has any tuples?

  1. SQL intersect

  2. SQL union

  3. SQL in

  4. SQL join

  5. SQL exists
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The 'SQL exists' simply tests whether the inner query returns any row. If it does, then the outer query proceeds. If not, the outer query does not execute, and the entire SQL statement returns nothing.

Keep practicing — related questions