Solution:Step 1: Apply UNION operationUNION removes duplicates, so (2, 'Ben') appears once.Step 2: Apply ORDER BY on combined resultOrdering by id gives rows sorted as (1, 'Anna'), (2, 'Ben'), (3, 'Cara').Final Answer:(1, 'Anna'), (2, 'Ben'), (3, 'Cara') -> Option BQuick Check:UNION removes duplicat

[Solved] Given two tables:table1 with values (1, 'Anna'), (2, 'Ben')table2 with values (2, 'Ben'), (3, 'Cara')What is the result of:SELECT id, name FROM table1 UNION SELECT id, name FROM table2 ORDER BY id;? | SQL

SQL - Set Operations

Given two tables:
table1 with values (1, 'Anna'), (2, 'Ben')
table2 with values (2, 'Ben'), (3, 'Cara')
What is the result of:
SELECT id, name FROM table1 UNION SELECT id, name FROM table2 ORDER BY id;?

A(2, 'Ben'), (3, 'Cara')

B(1, 'Anna'), (2, 'Ben'), (3, 'Cara')

C(1, 'Anna'), (2, 'Ben'), (2, 'Ben'), (3, 'Cara')

D(3, 'Cara'), (2, 'Ben'), (1, 'Anna')

Step-by-Step Solution

Solution:

Step 1: Apply UNION operation
UNION removes duplicates, so (2, 'Ben') appears once.
Step 2: Apply ORDER BY on combined result
Ordering by id gives rows sorted as (1, 'Anna'), (2, 'Ben'), (3, 'Cara').
Final Answer:
(1, 'Anna'), (2, 'Ben'), (3, 'Cara') -> Option B
Quick Check:
UNION removes duplicates, ORDER BY sorts final rows [OK]

Quick Trick: UNION removes duplicates before ORDER BY sorts [OK]

Common Mistakes:

MISTAKES

Expecting duplicate rows in UNION
Ignoring ORDER BY effect
Confusing UNION with UNION ALL

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

Given two tables:

Step 1: Apply UNION operation

Step 2: Apply ORDER BY on combined result

Final Answer:

Quick Check:

Want More Practice?