[Solved] Identify the error in this SQL query:SELECT name FROM table1 UNION ALL ORDER BY name SELECT name FROM table2; | SQL

SQL - Set Operations

Identify the error in this SQL query:

SELECT name FROM table1 UNION ALL ORDER BY name SELECT name FROM table2;

ASELECT statements must have different column names

BUNION ALL cannot be used with ORDER BY

CMissing semicolon after first SELECT

DORDER BY is placed incorrectly between UNION ALL and second SELECT

Step-by-Step Solution

Solution:

Step 1: Check UNION ALL syntax
UNION ALL combines two SELECT queries; ORDER BY must come after both queries, not between.
Step 2: Identify ORDER BY placement error
ORDER BY is incorrectly placed between UNION ALL and second SELECT, causing syntax error.
Final Answer:
ORDER BY is placed incorrectly between UNION ALL and second SELECT -> Option D
Quick Check:
ORDER BY after UNION ALL queries = D [OK]

Quick Trick: ORDER BY must follow all UNION ALL 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 this SQL query: