RANK « Analytical Functions « Oracle PL/SQL Tutorial

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: