[Solved] Find the error in this query:SELECT name FROM employees INTERSECT SELECT department FROM employees; — Ans: Columns in both SELECTs must have the same data type | SQL

SQL - Set Operations

Find the error in this query:
SELECT name FROM employees INTERSECT SELECT department FROM employees;

AColumns in both SELECTs must have the same data type

BINTERSECT cannot be used on the same table

CMissing WHERE clause in one SELECT

DNo error, query is valid

Step-by-Step Solution

Solution:

Step 1: Check column compatibility
INTERSECT requires both SELECT statements to have the same number and type of columns.
Step 2: Identify mismatch
Here, 'name' and 'department' likely have different data types, causing error.
Final Answer:
Columns in both SELECTs must have the same data type -> Option A
Quick Check:
INTERSECT needs matching column types [OK]

Quick Trick: INTERSECT requires same column types in both queries [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the error in this query: