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 MS SQL Server

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, there's just two of them this time.

Do you do any sports? If you do, this lecture's going to be right up your alley! We're going to be working with athletes this time and analyzing two tables that contain information about medals that various athletes 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;