题解 | #查找在职员工自入职以来的薪水涨幅情况#
查找在职员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
最简单的方法
SELECT emp_no,(max(salary)-MIN(salary))as growth FROM salaries
GROUP BY emp_no
having growth<>0
order by growth
查找在职员工自入职以来的薪水涨幅情况
http://www.nowcoder.com/practice/fc7344ece7294b9e98401826b94c6ea5
SELECT emp_no,(max(salary)-MIN(salary))as growth FROM salaries
GROUP BY emp_no
having growth<>0
order by growth
相关推荐