Solution:Step 1: Understand INTERSECT returns common rowsRows present in both tables A and B are returned.Step 2: Identify common rowsOnly (2, 'Bob') exists in both tables.Final Answer:2, 'Bob' -> Option BQuick Check:INTERSECT common rows = A [OK]

[Solved] Given these tables:Table A:id INT, name VARCHAR1, 'Alice'2, 'Bob'Table B:id INT, name VARCHAR2, 'Bob'3, 'Charlie'What is the result of:SELECT id, name FROM A INTERSECT SELECT id, name FROM B;? | SQL

SQL - Set Operations

Given these tables:

Table A:
id INT, name VARCHAR
1, 'Alice'
2, 'Bob'

Table B:
id INT, name VARCHAR
2, 'Bob'
3, 'Charlie'

What is the result of:
SELECT id, name FROM A INTERSECT SELECT id, name FROM B;?

A1, 'Alice'<br>2, 'Bob'<br>3, 'Charlie'

B2, 'Bob'

C1, 'Alice'<br>3, 'Charlie'

DNo rows returned

Step-by-Step Solution

Solution:

Step 1: Understand INTERSECT returns common rows
Rows present in both tables A and B are returned.
Step 2: Identify common rows
Only (2, 'Bob') exists in both tables.
Final Answer:
2, 'Bob' -> Option B
Quick Check:
INTERSECT common rows = A [OK]

Quick Trick: INTERSECT returns only rows in both sets [OK]

Common Mistakes:

MISTAKES

Including all rows from both tables
Confusing INTERSECT with UNION
Ignoring exact row matching

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given these tables:

Step 1: Understand INTERSECT returns common rows

Step 2: Identify common rows

Final Answer:

Quick Check:

Want More Practice?