ClimberCoding

SQL3 查找当前薪水详情以及部门编号dept_no 题目 题解 select s.*, d.dept_no from salaries as s join dept_manager as d on s.emp_no = d.emp_no order by s.emp_no;

SQL2 查找入职员工时间排名倒数第三的员工 题目 题解1 select * from employees order by hire_date desc limit 2, 1; 题解2 select * from employees where hire_date = ( select distinct hire_date from employees order by hire_date desc limit 2, 1); ...

SQL1 查找最晚入职员工的所有信息 题目 题解1 select * from employees order by hire_date desc limit 1; 题解2 select * from employees where hire_date = (select max(hire_date) from employees);