Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

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

NTILE

On this page

Syntax

Arguments

Return Type

Examples

Was this article helpful?

On this page

Was this article helpful?