foxmo

分类

题解(14)

/ 注册

全部文章（共12篇）

题解 | #获取所有非manager员工当前的薪水情况#

select de.dept_no,de.emp_no,s.salary from dept_emp as de inner join employees as e on de.emp_no =e.emp_no inner join salaries as s on de.emp_no = s.em...

Mysql

2021-11-20

1 258

题解 | #统计各个部门的工资记录数#

select de.dept_no,dept_name,count(*) as sum from dept_emp de inner join departments d on de.dept_no=d.dept_no inner join salaries s on de.emp_no=s.emp...

Mysql

2021-11-20

1 279