[Solved] Find the mistake in this query:SELECT name FROM table1 UNION SELECT name FROM table2 ORDER BY table1.name; | SQL

SQL - Set Operations

Find the mistake in this query:
SELECT name FROM table1 UNION SELECT name FROM table2 ORDER BY table1.name;

AUNION requires columns to be aliased

BORDER BY must come before UNION

CORDER BY cannot use table alias after UNION

DSELECT statements must have WHERE clause

Step-by-Step Solution

Solution:

Step 1: Understand ORDER BY scope after UNION
After UNION, the result is a combined set without table aliases.
Step 2: Check ORDER BY usage
ORDER BY cannot reference original table aliases; must use column names only.
Final Answer:
ORDER BY cannot use table alias after UNION -> Option C
Quick Check:
ORDER BY uses column names, not table aliases after UNION [OK]

Quick Trick: After UNION, ORDER BY uses column names only, no table aliases [OK]

Common Mistakes:

MISTAKES

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the mistake in this query: