SQL · Window functions

ntile()

Splits rows into roughly equal buckets.

sqlRunnable example sql course

Syntax

ntile(buckets) over (…)

Example

Open in the lab

WITH lessons(minutes) AS (VALUES (10), (20), (30), (40))
SELECT minutes, ntile(2) OVER (ORDER BY minutes) AS bucket FROM lessons;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.