#学习使用窗口函数rank，dense_rank，row_number
select s.emp_no,s.salary, dense_rank() OVER (ORDER by salary DESC) as t_rank
from (select *
from salaries
order by emp_no) as s