Question

Table B contains a NULL value in its 'id' column. Consider: SELECT * FROM A WHERE A.id NOT IN (SELECT id FROM

  • B . What happens?
A The query returns all rows from A regardless of matches, treating NULL as a wildcard
B The query returns no rows at all.
C The query returns all rows from A where id doesn't match any non-NULL value in B, ignoring the NULL entirely
D The query behaves identically to NOT EXISTS in all cases, including this one
E The query throws a syntax error because NOT IN cannot be used with subqueries containing NULLs
Practice Next

Hey! Ask a query

🎓
Think You're Ready for RBI Grade B?
RBI Grade B 2026 Phase 1 Memory Based Paper
  • 200 Questions with Detailed Solutions
  • Section-wise Coverage (GA, English, Quant & Reasoning)