[Solved] Identify the error in the following SQL query:SELECT name FROM Employees INTERSECT Employees2; — Ans: Missing SELECT keyword before second table | SQL

SQL - Set Operations

Identify the error in the following SQL query:
SELECT name FROM Employees INTERSECT Employees2;

ANo error, query is correct

BINTERSECT cannot be used with SELECT

CTable names cannot be used with INTERSECT

DMissing SELECT keyword before second table

Step-by-Step Solution

Solution:

Step 1: Check syntax for INTERSECT
Both sides of INTERSECT must be SELECT queries.
Step 2: Identify missing SELECT
The second part 'Employees2' lacks SELECT keyword, causing syntax error.
Final Answer:
Missing SELECT keyword before second table -> Option D
Quick Check:
Both sides must be SELECT queries [OK]

Quick Trick: Both sides of INTERSECT must be SELECT queries [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in the following SQL query: