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.

RANK

Syntax

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

Return Type

An integer

Example

The following example demonstrates how the partition clause groups results and then rank is applied to those groups. Order by orders the results.

SQL

CREATE TABLE rank_t (a int, b int);

INSERT INTO rank_t VALUES(1,1), (1,2), (3,2), (3,3), (3,-4);

SQL

SELECT a,b, RANK() OVER (PARTITION BY a ORDER BY b) FROM rank_t;

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

RANK

On this page

Syntax

Return Type

Example

Was this article helpful?

On this page

Was this article helpful?