题解 | 对所有员工的薪水按照salary降序进行1-N的排名
select emp_no,salary,dense_rank() over(order by salary desc) as t_rank from salaries where to_date='9999-01-01' order by t_rank asc,emp_no asc;
select emp_no,salary,dense_rank() over(order by salary desc) as t_rank from salaries where to_date='9999-01-01' order by t_rank asc,emp_no asc;
相关推荐
编程有术:那就投央国企就好了,学历足够 简历稍微润色下,做点项目,比如农发西安,中行西安,应该没问题,这俩单位都有同学在里面,反馈不错