Find the 90th-percentile style cutoff

sql

WITH scored AS (
  SELECT salary,
         CUME_DIST() OVER (ORDER BY salary) AS cd
  FROM employees
)
SELECT *
FROM scored
WHERE cd >= 0.90;

Explanation

This is an intuitive pattern when exact percentile functions are unavailable or vary by dialect.

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

Bucket rows into 10 groups.

Open In sheetsqlsame section

Relative standing from 0 to 1.

Open In sheetsqlsame section

Turn NTILE output into a simple segment label.

Assign named score ranges using a window bucket.