题解 | 查找在职员工自入职以来的薪水涨幅情况
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
with s2 as ( select emp_no ,salary as salary2 from ( select emp_no,salary from salaries where to_date='9999-01-01' ) t ), s1 as ( select e.emp_no, salary as salary1 from salaries s join employees e on e.emp_no=s.emp_no and hire_date =from_date ) select s2.emp_no,salary2-salary1 as growth from s2 join s1 on s1.emp_no=s2.emp_no order by growth;
美团成长空间 2667人发布
投递快手等公司9个岗位