Lesson 9.5 · Pro
NTILE and PERCENT_RANK
Split rows into equal-sized buckets like quartiles or percentiles.
In this lesson
- NTILE(n) makes n equal buckets
- NTILE(100) for percentiles
- PERCENT_RANK: where a row sits from 0 to 1
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.