select emp_no,salary,
    DENSE_RANK() OVER (order by salary DESC) as dr
from salaries
order by 
    salary DESC,
    emp_no ASC;