Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Very simple subqueries
Subqueries with multiple results
11. The operator ANY
Correlated subqueries
Other subqueries

Instruction

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

SELECT
  * 
FROM trip 
WHERE price < ANY (
  SELECT price 
  FROM hiking_trip 
  WHERE mountain_id = 1
);

In the above example, we want to find trips to the cities which 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 which costs 1000 and one which costs 300. If we find a city trip which is cheaper than any of these values, we show it in the result.

Again, other logical operators are possible: = ANY, =! ANY, < ANY, <= ANY, >= ANY.

Exercise

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

Stuck? Here's a hint!

Type:

SELECT
  * 
FROM trip 
WHERE price = ANY (
  SELECT price 
  FROM hiking_trip
);