查询每个部门的员工个数: select d.department_id, ( select count(*) from employees e where e.department_id = d.department_id ) 个数 from departments d; 一个直接的思路是将两张表外 Read More
posted @ 2021-07-22 19:58 imissinstagram Views(53) Comments(0) Diggs(0)