Introduction
Very simple subqueries
Subqueries with multiple results
Correlated 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
);
