DENSE_RANK « Analytical Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Analytical Functions
  3. DENSE_RANK
16.5.DENSE_RANK
16.5.1.Using the DENSE_RANK()
16.5.2.The DENSE_RANK and tie
16.5.3.See the top five salaries
16.5.4.Use ROW_NUMBER(), RANK() and DENSE_RANK() together
16.5.5.DENSE_RANK NULL value
16.5.6.NULLS LAST
16.5.7.NULLS FIRST
16.5.8.decode dense_rank