Important

New database features are no longer connected to engine versions; features are now enabled independently during scheduled update windows, and “major” and “minor” releases no longer exist in Helios. Please visit the release notes to view the latest features available in your database clusters.

NTILE

Syntax

NTILE ( bucket_count ) OVER (
    [PARTITION BY (col | expr), ...]
    [ORDER BY (col | expr), ...]
)

Arguments

bucket_count: An integer.

Return Type

An integer.

Examples

SQL

CREATE TABLE ntile_example (a int, b int);

INSERT INTO ntile_example VALUES(1,2),(2,2),(3,3),(4,3);

INSERT INTO ntile_example VALUES(3,2),(1,1),(3,1);

SQL

SELECT a,b, NTILE(3) OVER(ORDER BY a) FROM ntile_example;

+------+------+---------------------------+
| a    | b    | NTILE(3) OVER(ORDER BY a) |
+------+------+---------------------------+
|    1 |    2 |                         1 |
|    1 |    1 |                         1 |
|    2 |    2 |                         1 |
|    3 |    3 |                         2 |
|    3 |    2 |                         2 |
|    3 |    1 |                         3 |
|    4 |    3 |                         3 |
+------+------+---------------------------+