Lesson 9.2 · Pro
ROW_NUMBER, RANK and DENSE_RANK
Number rows within a group, and know exactly how each function handles ties.
In this lesson
- Three ways to number rows
- Pick the right one
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.