NTILE

How can we divide employees into four equal compensation quartiles?

Advanced⏱ 3 Minutes⭐ 1690 XP

🤔 THE QUESTION

How can we divide employees into four equal compensation quartiles?

💡 WHAT IS IT?

NTILE(N) divides an ordered partition into N equal buckets numbered from 1 to N.

🎯 WHAT IS IT USED FOR?

Customer RFM quartile segmentation, performance quartiles, risk deciles.

💻 EXAMPLE

SELECT
name,
salary,
NTILE(4) OVER (
    ORDER BY salary DESC
) AS salary_quartile
FROM employees;

Practice typing production-grade SQL code for NTILE.