Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
UNION
8. The keyword UNION ALL
INTERSECT
EXCEPT

Instruction

Good. By default, UNION removes duplicate rows. Luckily, we can change it. Just put UNION ALL instead of UNION in your query

SELECT *
FROM cycling
WHERE country = 'Germany'
UNION ALL
SELECT *
FROM skating
WHERE country = 'Germany';

... and you'll get all rows, even when they are the same.

Exercise

Show all countries which have medals in cycling or skating. Use a union. Don't remove duplicates.

Stuck? Here's a hint!

Type:

SELECT country
FROM cycling
UNION ALL
SELECT country
FROM skating;