EasyOutput prediction

UNION ALL keeps duplicates

Given these tables:

table_a:

name
Alice
Bob

table_b:

name
Bob
Carol

How many rows does UNION ALL return?

SELECT name FROM table_a
UNION ALL
SELECT name FROM table_b;

← → arrow keys to navigate

Sign in to save your progress.

UNION ALL keeps duplicates - SQL Set Operations Quiz | Unnested