题解 | 遇到这种题还是老是错
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
select tt.emp_no emp_no,(tt.salary-bb.salary) growth from (select t.salary,t.emp_no from salaries t where to_date='9999-01-01' ) tt inner join (select b.salary,b.emp_no from salaries b inner join employees em on b.emp_no=em.emp_no and b.from_date=em.hire_date) bb on tt.emp_no=bb.emp_no order by growth
查看18道真题和解析