#在select后面再一次使用select
#查询每个部门的员工个数
SELECT d.*,(
SELECT COUNT(*)
FROM employees AS e
WHERE d.`department_id` = e.`department_id`
)
#在select后面再一次使用select
#查询每个部门的员工个数
SELECT d.*,(
SELECT COUNT(*)
FROM employees AS e
WHERE d.`department_id` = e.`department_id`
)