继续寻梦
继续寻梦
全部文章
分类
题解(3)
归档
标签
去牛客网
登录
/
注册
继续寻梦的博客
全部文章
(共3篇)
题解 | #查找在职员工自入职以来的薪水涨幅情况#
SELECT s1.emp_no,s2.salary - s1.salary growth FROM (SELECT salaries.emp_no,salary FROM salaries ,employees WHERE salaries.from_date = employees.hire...
2021-06-10
0
319
题解 | #获取每个部门中当前员工薪水最高的相关信息#
select s1.dept_no,s2.emp_no,s1.maxSalary from (select dept_emp.dept_no,max(salary) maxSalary from de...
2021-06-09
1
359
题解 | #获取所有员工当前的manager#
select t1.emp_no,t2.emp_no manager from dept_emp t1 left join dept_manager t2 on t1.dept_no = t2.dept_no where t1.emp_no != t2.emp_no;
2021-06-09
1
343