Which of the following SQL statements correctly uses EXCEPT to find rows in employees that are not in managers?

easy📝 Syntax Q3 of 15

SQL - Set Operations

Which of the following SQL statements correctly uses EXCEPT to find rows in employees that are not in managers?

ASELECT employee_id FROM employees MINUS employee_id FROM managers;

BSELECT employee_id FROM employees EXCEPT SELECT employee_id FROM managers;

CSELECT employee_id FROM employees EXCEPT employee_id FROM managers;

DSELECT employee_id FROM employees WHERE employee_id NOT IN managers;

Step-by-Step Solution

Solution:

Step 1: Check syntax for EXCEPT
The correct syntax requires two SELECT statements separated by EXCEPT.
Step 2: Analyze options
SELECT employee_id FROM employees EXCEPT SELECT employee_id FROM managers; correctly uses two SELECT queries with EXCEPT. SELECT employee_id FROM employees MINUS employee_id FROM managers; uses MINUS but without SELECT in second part, which is invalid. SELECT employee_id FROM employees EXCEPT employee_id FROM managers; misses SELECT in second part. SELECT employee_id FROM employees WHERE employee_id NOT IN managers; uses WHERE NOT IN, which is different.
Final Answer:
SELECT employee_id FROM employees EXCEPT SELECT employee_id FROM managers; -> Option B
Quick Check:
Two SELECTs separated by EXCEPT is correct syntax [OK]

Quick Trick: EXCEPT requires two complete SELECT statements [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes