题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
with t1 as (select emp_no,max(salary) salary_max from salaries where to_date='9999-01-01' group by emp_no), t2 as (select s.emp_no,s.salary from salaries s inner join employees e on s.emp_no=e.emp_no where s.from_date=e.hire_date) select t1.emp_no,t1.salary_max-t2.salary growth from t1 left join t2 on t1.emp_no=t2.emp_no order by growth asc;
SHEIN希音公司福利 256人发布