Q. The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are . . . . . . . .

  • (A) IN and NOT IN
  • (B) WHERE
  • (C) OUTER JOIN and INNER JOIN
  • (D) LEFT JOIN and RIGHT JOIN
💬 Discuss
✅ Correct Answer: (A) IN and NOT IN
Explanation: This question is about how to handle situations where a subquery (a query nested inside another query) returns multiple results.

Published by Vikash Gupta ⭐ 33.56K Points at 22-Mar-2025 12:46 pm in MySQL

Explanation by: Vikash Gupta
This question is about how to handle situations where a subquery (a query nested inside another query) returns multiple results.

💬 Discussion

📊 Question Analytics

👁️
111
Total Visits
📽️
1 y ago
Published
🎖️
Vikash Gupta
Publisher
📈
82%
Success Rate