select emp_no,salary,
dense_rank() over(order by salary desc) as rank
from salaries
where to_date='9999-01-01'
order by rank,emp_no asc窗口函数：https://blog.csdn.net/weixin_43412569/article/details/107992998
select emp_no,salary,
dense_rank() over(order by salary desc) as rank
from salaries
where to_date='9999-01-01'
order by rank,emp_no asc窗口函数：https://blog.csdn.net/weixin_43412569/article/details/107992998
牛客博客，记录你的成长
京公网安备 11010502036488号