[Solved] Find the issue in this query:SELECT id FROM table1 EXCEPT SELECT name FROM table2; — Ans: SELECT statements must have same number of columns and compatible types | SQL

SQL - Set Operations

Find the issue in this query:
SELECT id FROM table1 EXCEPT SELECT name FROM table2;

AColumn names must match in both SELECT statements

BSELECT statements must have same number of columns and compatible types

CEXCEPT requires WHERE clause

DEXCEPT cannot compare different tables

Step-by-Step Solution

Solution:

Step 1: Check column compatibility
EXCEPT requires both SELECTs to have same number of columns with compatible data types.
Step 2: Identify mismatch
First SELECT uses 'id', second uses 'name' which may differ in type or meaning.
Final Answer:
SELECT statements must have same number of columns and compatible types -> Option B
Quick Check:
EXCEPT needs matching columns and types [OK]

Quick Trick: EXCEPT requires matching columns and data types [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the issue in this query: