实例 PostgreSQL ALL 运算符实例

 
SELECT product_name
FROM products
WHERE product_id = ALL (
  SELECT product_id
  FROM order_details
  WHERE quantity > 10
);        
                    

输出结果

 product_name
--------------
(0 rows)