select a.emp_no,a.salary,(
select count(distinct c.salary) from salaries c where c.salary>=a.salary
) t_rank
from salaries a
order by a.salary desc,a.emp_no asc