Bucket rows with NTILE

sql

SELECT customer_id, total_spent,
       NTILE(4) OVER (ORDER BY total_spent DESC) AS quartile
FROM customer_lifetime_value;

Explanation

NTILE is helpful for quartiles, deciles, and score bands.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Buckets and Percentiles

Measure relative row position inside an ordered set.

Open In sheetsqlsame section

Number rows within an ordered partition.

Open In sheetsql1 tag match

Read a value from the previous row in the same partition.

Open In sheetsql1 tag match

Assign ordered rankings with or without gaps.

Open In sheetsql1 tag match

Read a value from the next row in the same partition.

Open In sheetsql1 tag match

Accumulate values across an ordered window.

Open In sheetsql1 tag match