搞定排序任务!详解SQL窗口函数的妙用
最编程
2024-01-22 13:12:42
...
例如:题目源自牛客网
代码:
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;
推荐阅读