1. Learn
    2. /
  2. Courses
    3. /
  3. Joining Data in SQL

Exercise

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.

Instructions 1/3

undefined XP
    1
    2
    3

Question

What result will the following SQL query produce?

SELECT * 
FROM languages
UNION
SELECT * 
FROM currencies;

Possible answers