实现dense_rank()和rank() 在于加粗部分是否去重
select emp_no,salary,(select count(distinct salary ) from
salaries s2 where
s1.salary<=s2.salary and to_date='9999-01-01') from salaries s1
where to_date='9999-01-01'
order by 3,1 asc
实现dense_rank()和rank() 在于加粗部分是否去重
select emp_no,salary,(select count(distinct salary ) from
salaries s2 where
s1.salary<=s2.salary and to_date='9999-01-01') from salaries s1
where to_date='9999-01-01'
order by 3,1 asc