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
Very simple subqueries
Subqueries with multiple results
Correlated subqueries
17. The EXISTS operator with NOT
Other subqueries

Instruction

Good! Remember the NOT operator? We can use it together with EXISTS. Take a look:

SELECT
  *
FROM City
WHERE NOT EXISTS (
  SELECT
    *
  FROM Trip
  WHERE Trip.CityID = City.ID
);

As you probably guessed, this query will find all cities that don't have any trips organized in them.

Exercise

Select all mountains with no hiking trips to them.

Stuck? Here's a hint!

Type:

SELECT
  *
FROM Mountain
WHERE NOT EXISTS (
  SELECT
    *
  FROM HikingTrip
  WHERE HikingTrip.MountainID = Mountain.ID
);