What does NTILE do and where is it used?

SQL window functions · Experienced

Model answer

NTILE(n) divides ordered rows into n roughly equal buckets (for example quartiles or percentiles) and returns the bucket number. It is used for segmenting customers into groups by spend.

Learn this topic

Window Functions: ROW_NUMBER, RANK and Running Totals in the course SQL for Beginners: Learn Databases Step by Step.

Sign in to add your own answer.

More questions

• What is a window function and how is it different from GROUP BY?
• What is the difference between ROW_NUMBER, RANK and DENSE_RANK?
• What do PARTITION BY and ORDER BY do inside OVER?
• What do LAG and LEAD do?
• How do you calculate a running total?
• How do you find consecutive days (gaps and islands)?