#初始语法
SELECT EXISTS (SELECT `department_id` FROM `employees`) AS 存在;
#判断是否存在
#查询有员工的部门名
SELECT `department_name`
FROM `departments` AS d
WHERE EXISTS(
SELECT `department_id`
FROM `employees` AS e
WHERE d.`department_id` = e.`department_id`
);
#查询没有女朋友的女神信息
SELECT bo.*
FROM `boys` bo
WHERE NOT EXISTS(
SELECT `boyfriend_id`
FROM `beauty` AS b
WHERE b.`boyfriend_id` = bo.`id`
);