【SQL】排名

select emp_no, salary, DENSE_RANK() OVER(order by [salary]desc) as rank
from salaries
where to_date=‘9999-01-01‘
order by salary desc, emp_no

select a.emp_no,a.salary,(select count(distinct b.salary)from salaries b
where b.to_date=‘9999-01-01‘ and b.salary>a.salary)+1 as rank
from salaries a where a.to_date=‘9999-01-01‘
order by salary desc,emp_no