Important

The SingleStore 9.1 release candidate (RC) is available now. It will be promoted to general availability (GA) soon and at that time it will be renamed to SingleStore 10.

In the interim, SingleStore 9.1 RC can be used to preview, evaluate, and provide feedback on the new and upcoming features in SingleStore 10, while SingleStore 9.0 is recommended for production workloads.

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 |
+------+------+---------------------------+