实例 PostgreSQL ANY 运算符实例

 
SELECT product_name
FROM products
WHERE product_id = ANY (
  SELECT product_id
  FROM order_details
  WHERE quantity > 120
);        
                    

输出结果

        product_name
---------------------------
 Chartreuse verte
 Wimmers gute Semmelknadel
(2 rows)