Solution:Step 1: List rows from both tablestable_a has ids 1, 2, 3; table_b has ids 2, 3, 4.Step 2: Find common ids using INTERSECTCommon ids are 2 and 3 only.Final Answer:[2, 3] -> Option CQuick Check:INTERSECT = common rows = [2, 3] [OK]

[Solved] Given these tables:table_a:id123table_b:id234What is the result of:SELECT id FROM table_a INTERSECT SELECT id FROM table_b; | PostgreSQL

PostgreSQL - Set Operations and Advanced Queries

Given these tables:
table_a:
id
1
2
3

table_b:
id
2
3
4

What is the result of:
SELECT id FROM table_a INTERSECT SELECT id FROM table_b;

A[1, 2, 3]

B[1]

C[2, 3]

D[4]

Step-by-Step Solution

Solution:

Step 1: List rows from both tables
table_a has ids 1, 2, 3; table_b has ids 2, 3, 4.
Step 2: Find common ids using INTERSECT
Common ids are 2 and 3 only.
Final Answer:
[2, 3] -> Option C
Quick Check:
INTERSECT = common rows = [2, 3] [OK]

Quick Trick: INTERSECT returns only ids present in both tables [OK]

Common Mistakes:

Including ids only in one table
Confusing INTERSECT with UNION
Expecting all ids combined

Master "Set Operations and Advanced Queries" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Given these tables:

Step 1: List rows from both tables

Step 2: Find common ids using INTERSECT

Final Answer:

Quick Check:

Want More Practice?