Rank « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. Rank
1.RANK(): rank items, leaves a gap in the sequence when there is a tie
2.The ranking as opposed to a row-numbering problem (the problem of ties)
3.The WHERE is applied before the RANK()
4.Rank with order by clause
5.When RANK() is added to the statement, the RANK function is applied last, just before the ordering
6.RANK() with NULLS LAST demo
7.RANK() with NULLS FIRST
8.Rank(): If the statement requests another ordering, another sort may result
9.Rank() with null values




10.Rank() over partition
11.Browse Products with ranking function
12.rank() over (partition by deptno order by sal desc )