Solution:Step 1: Combine rows with UNIONUNION merges rows from both tables and removes duplicates, so (2, 'Bob') appears once.Step 2: Sort combined results by idOrdering by id gives rows in order: 1, 2, 3.Final Answer:(1, 'Alice'), (2, 'Bob'), (3, 'Charlie') -> Option AQuick Check:UNION removes dupl

[Solved] Given two tables:table1 with values (1, 'Alice'), (2, 'Bob')table2 with values (2, 'Bob'), (3, 'Charlie')What is the result of this query?... | SQL

SQL - Set Operations

Given two tables:
table1 with values (1, 'Alice'), (2, 'Bob')
table2 with values (2, 'Bob'), (3, 'Charlie')
What is the result of this query?

SELECT id, name FROM table1 UNION SELECT id, name FROM table2 ORDER BY id;

A(1, 'Alice'), (2, 'Bob'), (3, 'Charlie')

B(1, 'Alice'), (2, 'Bob'), (2, 'Bob'), (3, 'Charlie')

C(2, 'Bob'), (3, 'Charlie')

D(1, 'Alice'), (3, 'Charlie')

Step-by-Step Solution

Solution:

Step 1: Combine rows with UNION
UNION merges rows from both tables and removes duplicates, so (2, 'Bob') appears once.
Step 2: Sort combined results by id
Ordering by id gives rows in order: 1, 2, 3.
Final Answer:
(1, 'Alice'), (2, 'Bob'), (3, 'Charlie') -> Option A
Quick Check:
UNION removes duplicates, ORDER BY sorts = B [OK]

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

Common Mistakes:

MISTAKES

Expecting duplicates with UNION
Ignoring ORDER BY sorting
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: Combine rows with UNION

Step 2: Sort combined results by id

Final Answer:

Quick Check:

Want More Practice?