Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Basics in PostgreSQL

Introduction
UNION
8. The keyword UNION ALL
INTERSECT
EXCEPT

Instruction

Good. By default, UNION removes duplicate rows. Luckily, we can change this. 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;