DENSE_RANK « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. DENSE_RANK
1.DENSE_RANK()rank items, leaves no gaps when there is a tie
2.Deal with Null in Rank
3.Deal with Null in dense_rank
4.DENSE_RANK() with NULLS FIRST
5.DENSE_RANK() with NULLS LAST
6.DENSE_RANK function
7.Use DENSE_RANK() to get the top rank
8.Compare rank() and dense_rank()
9.dense_rank() over (order by comm desc nulls last)




10.Use rank and dense_rank in subquery
11.decode dense_rank
12.dense_rank() over ( partition by deptno order by sal desc )
13.rank and dense_rank with group by