MySQL_子查询_放在select后面

仅仅支持 标量子查询

案例

#查询每个部门的员工个数

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