SQL - Set Operations
Which SQL clause is used to retrieve only the rows that exist in both of two SELECT query results?
Which SQL clause is used to retrieve only the rows that exist in both of two SELECT query results?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the purpose
The question asks for rows common to both SELECT queries.Step 2: Recall SQL set operators
INTERSECT returns common rows, UNION combines all rows, JOIN combines rows based on keys, EXCEPT returns rows in first query not in second.Final Answer:
INTERSECT -> Option AQuick Check:
INTERSECT finds common rows [OK]
Quick Trick: Use INTERSECT to get common rows from two queries [OK]
Common Mistakes:
MISTAKES- Choosing UNION which merges all rows
- Confusing JOIN with INTERSECT
- Using EXCEPT which excludes rows
Master "Set Operations" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes