[Solved] Consider these tables:employees:id101102103managers:id102104What does this query return?SELECT id FROM employees EXCEPT SELECT id FROM managers; | SQL

SQL - Set Operations

Consider these tables:
employees:
id
101
102
103

managers:
id
102
104

What does this query return?
SELECT id FROM employees EXCEPT SELECT id FROM managers;

A104

B101, 103

C101, 102, 103, 104

D102, 104

Step-by-Step Solution

Solution:

Step 1: List employee ids
Employees have ids 101, 102, 103.
Step 2: List manager ids
Managers have ids 102, 104.
Step 3: Find employees not managers
Ids 101 and 103 are in employees but not in managers.
Final Answer:
101, 103 -> Option B
Quick Check:
EXCEPT filters out common ids [OK]

Quick Trick: EXCEPT filters out common rows from first query [OK]

Common Mistakes:

MISTAKES

Including ids only in second table
Listing all ids from both tables
Confusing EXCEPT with UNION

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

Consider these tables:

Step 1: List employee ids

Step 2: List manager ids

Step 3: Find employees not managers

Final Answer:

Quick Check:

Want More Practice?