exists后面的子查询

exists后面（相关子查询）

SELECT EXISTS(SELECT employee_id FROM employees);

结果是一个布尔类型的

SELECT EXISTS(SELECT employee_id FROM employees);

语法：
exists(完整的查询语句)
结果：
1或0

SELECT EXISTS(SELECT employee_id FROM employees WHERE salary = 30000);

案例1：查询有员工的部门名

SELECT department_name
FROM departments d
WHERE EXISTS(
			SELECT *
			FROM employees e
			WHERE d.'department_id' = e.'department_id'
			);