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