All/Any operator-really interesting

PHOTO EMBED

Sat Aug 20 2022 01:09:19 GMT+0000 (UTC)

Saved by @vnmshenoy

SELECT *
FROM CITY
where population < ALL
(select population
 from country) 

  -- same way you have ANY operator as well

  SELECT *
  FROM TRIP
  WHERE price = ANY(
  SELECT price 
  FROM HIKING_TRIP)
content_copyCOPY

https://learnsql.com/track/sql-from-a-to-z/course/sql-queries/subqueries/multiple-results/all