PostgreSQL

PostgreSQL ALL

Compare a value with every value returned by a subquery.

Use ALL

SELECT * FROM products
WHERE year > ALL (
  SELECT year FROM discontinued_products
);

The condition is true only when the comparison succeeds for every subquery result. Be aware that null values can produce an unknown result.