[Solved] What will be the output of the following query?SELECT name FROM table1 UNION ALL SELECT name FROM table2 ORDER BY name DESC;Given:table1: ('John', 'Alice')table2: ('Alice', 'Bob') | SQL

SQL - Set Operations

What will be the output of the following query?
SELECT name FROM table1 UNION ALL SELECT name FROM table2 ORDER BY name DESC;
Given:
table1: ('John', 'Alice')
table2: ('Alice', 'Bob')

AJohn, Alice, Bob

BJohn, Bob, Alice, Alice

CJohn, Bob, Alice

DJohn, Bob, Alice, Alice (sorted descending)

Step-by-Step Solution

Solution:

Step 1: Understand UNION ALL behavior
UNION ALL keeps duplicates, so 'Alice' appears twice.
Step 2: Apply ORDER BY name DESC
Sorting descending by name gives: 'John', 'Bob', 'Alice', 'Alice'.
Final Answer:
John, Bob, Alice, Alice (sorted descending) -> Option D
Quick Check:
UNION ALL keeps duplicates, ORDER BY sorts descending [OK]

Quick Trick: UNION ALL keeps duplicates; ORDER BY sorts final list [OK]

Common Mistakes:

MISTAKES

Removing duplicates with UNION ALL
Sorting ascending instead of descending
Ignoring duplicate 'Alice'

Master "Set Operations" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

What will be the output of the following query?

Step 1: Understand UNION ALL behavior

Step 2: Apply ORDER BY name DESC

Final Answer:

Quick Check:

Want More Practice?