题解 | #统计各个部门的工资记录数#
统计各个部门的工资记录数
http://www.nowcoder.com/practice/6a62b6c0a7324350a6d9959fa7c21db3
SELECT dm.*, ds.sum FROM departments dm INNER JOIN ( SELECT d.dept_no, COUNT(*) AS sum FROM salaries s INNER JOIN dept_emp d ON s.emp_no = d.emp_no GROUP BY dept_no ) AS ds ON dm.dept_no = ds.dept_no ORDER BY dm.dept_no ASC
查看15道真题和解析
投递特斯拉等公司10个岗位
