DENSE_RANK
A Window Function that ranks rows without gaps after ties: 1, 2, 2, 3, 4. RANK leaves gaps instead: 1, 2, 2, 4, 5.
SELECT title, rental_rate,
DENSE_RANK() OVER (ORDER BY rental_rate DESC) AS rate_rank
FROM film;
When to use
Covered only in the reading's window-functions section. No past-paper or problem-set question uses it.
See Read 01.