11.1select后面的子查询——MySQL

-- 放在select后面的子查询  (用的很少，被弱化)
-- 仅仅支持标量子查询

-- 案例：查询每个部门的员工个数
SELECT d.*,(
				SELECT COUNT(*) 
				FROM employees e
				WHERE e.department_id=d.department_id
) number
FROM departments d;

-- 案例：查询员工号=102的部门名
SELECT (
				SELECT department_name
				FROM departments d
				JOIN employees e
				ON d.department_id=e.department_id
				WHERE e.employee_id=102
) 部门名;