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
2. Get to know the tables
UNION
INTERSECT
EXCEPT

Instruction

Okay, let's introduce the tables we'll have as our guests today. Fortunately, just two of them this time.

Do you do play sport? Even if not, we're going to deal with sportsmen and sportswomen this time. We're going to analyze two tables which contain information about medals that various people won in two Olympic disciplines. Let's check them out.

Exercise

Display the contents of the cycling table.

Stuck? Here's a hint!

Type:

SELECT *
FROM cycling;