SQL EXISTS¶

EXISTS 用于判断子查询是否返回至少一行结果。

示例¶

SELECT name
FROM users AS u
WHERE EXISTS (
  SELECT 1
  FROM orders AS o
  WHERE o.user_id = u.id
);

查询至少存在一条订单记录的用户。