题解 | 查找在职员工自入职以来的薪水涨幅情况
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select a.emp_no, (b.salary-a.salary) growth from (select e.emp_no,salary,from_date from employees e,salaries s where e.emp_no=s.emp_no and e.hire_date=s.from_date) a, -- 筛选出在职的 初始工资 (select emp_no,salary,to_date from salaries where to_date="9999-01-01") b -- 筛选出在职员工的目前薪资 where a.emp_no=b.emp_no order by growth
查看21道真题和解析