题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
SELECT b.emp_no,(xzgz-csgz) as growth FROM (select e.emp_no,s.salary as csgz,s.to_date from employees e inner join salaries s on e.emp_no=s.emp_no where e.hire_date=s.from_date ) as b INNER JOIN ( select e.emp_no,s.salary as xzgz,s.to_date as tzrq from employees e inner join salaries s on e.emp_no=s.emp_no where e.hire_date<>s.from_date ) as a on b.emp_no=a.emp_no WHERE a.tzrq='9999-01-01' order by growth asc; 引用了初始工资和现在工资的思路。
投递深信服等公司10个岗位