RANK « Analytical Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Analytical Functions
  3. RANK
16.4.RANK
16.4.1.Using the RANK()
16.4.2.WHERE is applied before the RANK()
16.4.3.The RANK function will not only produce the row numbering but will skip a rank if there is a tie
16.4.4.RANK NULL value
16.4.5.NULLS LAST demo
16.4.6.NULLS FIRST demo
16.4.7.Use GROUPING SETS and RANK() to get just the salary subtotal rankings: