大行行
大行行
全部文章
题解
归档
标签
去牛客网
登录
/
注册
大行行的博客
全部文章
/ 题解
(共17篇)
题解 | #查找在职员工自入职以来的薪水涨幅情况#
select t1.emp_no,(t1.sTo-t2.sHire) as growthfrom(select s.emp_no,s.salary as sTo from salaries as s inner join employees as e on s.emp_no=e.emp_no...
2021-07-27
0
289
题解 | #查找所有员工的last_name和first_name以及对应的dept_name#
select em.last_name,em.first_name,depa.dept_namefrom (employees as em left join dept_emp as dep on em.emp_no = dep.emp_no)left join departments as dep...
2021-07-27
0
283
题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
select e.emp_no,max(s.salary),e.last_name,e.first_namefrom employees as e inner join salaries as s on e.emp_no = s.emp_nowhere s.salary < (select m...
2021-07-27
0
290
题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#
select t.title,avg(s.salary) fromtitles as t inner join salaries as s on t.emp_no = s.emp_nogroup by title order by avg(s.salary) 首先做个表链接,然后将输出写出来,就是t...
2021-07-27
1
520
题解 | 每个部门中当前员工薪水最高的相关信息#
select de.dept_no,s.emp_no, max(s.salary) fromdept_emp as de inner join salaries as s on de.emp_no = s.emp_nogroup by de.dept_no order by de.dept_no ...
2021-07-27
1
339
题解 | #获取所有非manager的员工emp_no#
select de.emp_no,dm.emp_no from dept_emp as de inner join dept_manager as dm on de.dept_no = dm.dept_no where de.emp_no != dm.emp_no 本题给出了两个表,一个员工表,一个...
2021-07-26
2
348
题解 | #获取所有非manager的员工emp_no#
select emp_no from employees where emp_no not in (select emp_no from dept_manager) 首先分析两个表的差异表employees中有两个emp_no表dept_manager中有三个emp_no 表employees中的...
2021-07-26
1
316
首页
上一页
1
2
下一页
末页