个人提交答案汇总,part1
解答比较繁琐,有建议或好的想法欢迎评论区指出探讨=w=
1、查找最晚入职员工的所有信息
select *
from employees
where hire_date = (
select max(hire_date) from employees);
2、查找入职员工时间排名倒数第三的员工所有信息
//第一种(注意rank的用法)
select * from employees
where hire_date == (
select hire_date from (
select rank() over( order by hire_date desc ) as rank, hire_date
from employees ) a
where rank = 3
)
//第二种(注意limit的用法)
select * from employees order by hire_date desc limit 2,1;
3、查找各个部门领导薪水详情以及其对应部门编号dept_no
select salaries.emp_no