Create deciles with NTILE(10)

sql

SELECT customer_id,
       spend,
       NTILE(10) OVER (ORDER BY spend DESC) AS spend_decile
FROM customers;

Explanation

Great for segmentation, scoring, and rough percentile groupings.

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 Distribution functions

Relative standing from 0 to 1.

Open In sheetsqlsame section

Identify rows at or above a cumulative threshold.

Open In sheetsqlsame section

Turn NTILE output into a simple segment label.

Assign named score ranges using a window bucket.