UNION vs. UNION ALL

Nice work learning all about UNION and UNION ALL!

Two tables, languages and currencies, are provided. Run the queries provided in the console and select the correct answer for the multiple-choice questions in this exercise.

Question

What result will the following SQL query produce?

SELECT * 
FROM languages
UNION
SELECT * 
FROM currencies;

Possible answers

All records from both tables, dropping duplicate records (if any)

A SQL error, because languages and currencies do not have the same number of fields

A SQL error, because languages and currencies do not have the same number of records

Exercise

UNION vs. UNION ALL

Instructions 1/3

Question

Possible answers