题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
with t as( select s.emp_no,s.salary,e.hire_date,s.from_date from salaries s inner join employees e on s.emp_no=e.emp_no having s.from_date =e.hire_date) select t.emp_no,(s.salary-t.salary) growth from ( select * from salaries where to_date ='9999-01-01') s inner join t on t.emp_no=s.emp_no order by growth;
投递阿里巴巴集团等公司10个岗位 >
腾讯开奖325人在聊
