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
11. The ANY operator
Correlated subqueries
Other subqueries

Instruction

Good! To sum up this section, let's learn about one more operator: ANY. Take a look:

SELECT
  *
FROM Trip
WHERE Trip.Price < ANY (
  SELECT
    HikingTrip.Price
  FROM HikingTrip
  WHERE HikingTrip.MountainID = 1
);

In the above example, we want to find trips to the cities that are cheaper than any hiking trip to the mountain with ID 1 (Mont Blanc, just to let you know). There are two hiking trips to Mont Blanc: one that costs 1000 and one that costs 300. If we find a city trip that is cheaper than either of these hiking trips, we will show it in the result.

Again, other logical operator combinations are possible: = ANY, != ANY, > ANY, <= ANY, or >= ANY.

Exercise

Find all information about all city trips that have the same price as any hiking trip.

Stuck? Here's a hint!

Type:

SELECT
  *
FROM Trip
WHERE Trip.Price = ANY (
  SELECT
    HikingTrip.Price
  FROM HikingTrip
);