自存 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
https://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
SELECT emp_no, (SELECT salary FROM salaries WHERE to_date='9999-01-01' AND emp_no=s.emp_no)-(SELECT salary FROM salaries WHERE from_date=hire_date AND emp_no=s.emp_no) AS growth FROM salaries s JOIN employees USING(emp_no) GROUP BY emp_no HAVING MAX(to_date)='9999-01-01' ORDER BY growth
存一下自己写的💩，感觉写麻烦了
投递科大讯飞等公司6个岗位