ROW_NUMBER « Analytical Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Analytical Functions
  3. ROW_NUMBER
1.ROW_NUMBER(): return a number with each row in a group, starting at 1
2.ROW_NUMBER function with an ordering on salary in descending order
3.More Than One Analytical Function May Be Used in a Single Statement ROW_NUMBER(), RANK(), DENSE_RANK()
4.ROW_NUMBER() with order in descending order
5.Rank() with nulls last
6.row_number over partition by and order by
7.Sum over and row_number() over
8.Decode the result from row_number over, partition by, order by
9.Open a cursor created by using row_number function




10.Create a view based on row_number function
11.row_number() over (partition by deptno order)