[Solved] What will be the output of this query?SELECT id FROM Table1 INTERSECT SELECT id FROM Table2;Given:Table1: {10, 20, 30}Table2: {20, 30, 40} | SQL

SQL - Set Operations

What will be the output of this query?
SELECT id FROM Table1 INTERSECT SELECT id FROM Table2;
Given:
Table1: {10, 20, 30}
Table2: {20, 30, 40}

A{20, 30}

B{10, 20, 30, 40}

C{10}

D{} (empty set)

Step-by-Step Solution

Solution:

Step 1: Understand INTERSECT operation
INTERSECT returns only rows present in both tables.
Step 2: Find common rows
Common ids between Table1 and Table2 are 20 and 30.
Final Answer:
{20, 30} -> Option A
Quick Check:
INTERSECT = common rows only [OK]

Quick Trick: INTERSECT returns only shared rows between tables [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What will be the output of this query?