[Solved] Identify the error in the following SQL statement:SELECT id FROM table1 UNION SELECT id FROM table2 ORDER BY 2; | SQL

SQL - Set Operations

Identify the error in the following SQL statement:
SELECT id FROM table1 UNION SELECT id FROM table2 ORDER BY 2;

AMissing semicolon at the end

BUNION cannot be used with ORDER BY

CSELECT statements must have aliases

DORDER BY 2 is invalid because there is only one column

Step-by-Step Solution

Solution:

Step 1: Analyze ORDER BY clause
ORDER BY 2 means order by second column, but query selects only one column.
Step 2: Confirm UNION and ORDER BY usage
UNION with ORDER BY is valid if ORDER BY references existing columns.
Final Answer:
ORDER BY 2 is invalid because there is only one column -> Option D
Quick Check:
ORDER BY column index must exist [OK]

Quick Trick: ORDER BY column index must be within selected columns [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 statement: