示例
示例
SELECT * FROM products
WHERE price > ALL (SELECT price FROM products WHERE category = 'A');
-- 比 A 类商品都贵
SELECT * FROM users
WHERE id = ANY (SELECT user_id FROM orders WHERE amount > 1000);
-- 与 IN 等价| = ANY | 等价 IN |
|---|---|
| <> ALL | 等价 NOT IN（同样有 NULL 陷阱） |
| PostgreSQL 扩展 | 支持数组：id = ANY(ARRAY[1,2,3]) |
| MySQL | ANY/SOME 同义，用于子查询比较 |