MySQL 子查询之select后面

子查询select后面

仅仅支持标量子查询

#案例:查询每个部门的员工个数

SELECT d.*,(
	SELECT COUNT(*)
	FROM employees e
	WHERE e.department_id = d. department_id
) 个数
FROM departments d;

#案例2：查询员工号=102的部门名

SELECT(
	SELECT department_name
	FROM departments
	INNER JOIN employees
	ON employees.`department_id`=departments.`department_id`
	WHERE employee_id = 102

) 部门名;