A NOT IN query will return rows if a NULL value is in the subquery or IN list
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- The value returned by the subquery is used by the main query.
- The value returned by the subquery is used by the main query.
- The value returned by the subquery is used by the main query.
- The value returned by the subquery is used by the main query.
- subqueries cannot have union
- Which of the following does not hold true for the subqueries?
- Can we use a subquery in insert statement
- What is returned from the query SELECT NVL2(NULL,'V1','V2') from DUAL;