wzying

分类

/ 注册

全部文章（共34篇）

题解 | #获取当前薪水第二多员工emp_no以及对应薪水#

select a.emp_no,b.salary,a.last_name,a.first_name from employees a join salaries b on a.emp_no=b.emp_no where salary= ( select max(sal...

2023-03-15

1 335

题解 | #查找当前薪水详情以及部门编号dept_no#

select a.emp_no,a.salary,a.from_date,a.to_date,b.dept_no from salaries a join dept_manager b on a.emp_no=b.emp_no order by a.emp_no asc;;

2023-03-15

0 245

题解 | #查找入职员工时间排名倒数第三的员工所有信息#

select * from employees where hire_date= (select max(hire_date) from employees where hire_date< ( select max(hire_date) from employees where hire...

2023-03-15

0 196

题解 | #查找最晚入职员工的所有信息#

select * from employees where hire_date= (select max(hire_date) from employees);

2023-03-15

0 233