Skip to main content
Skip to main content

WINDOW-FUNCTION-ROW_NUMBER

WINDOW FUNCTION ROW_NUMBER​

description​

Returns a continuously increasing integer starting from 1 for each row of each Partition. Unlike RANK() and DENSE_RANK(), the value returned by ROW_NUMBER() does not repeat or appear vacant, and is continuously incremented.

ROW_NUMBER() OVER(partition_by_clause order_by_clause)

example​

select x, y, row_number() over(partition by x order by y) as rank from int_t;

| x | y | rank |
|---|------|----------|
| 1 | 1 | 1 |
| 1 | 2 | 2 |
| 1 | 2 | 3 |
| 2 | 1 | 1 |
| 2 | 2 | 2 |
| 2 | 3 | 3 |
| 3 | 1 | 1 |
| 3 | 1 | 2 |
| 3 | 2 | 3 |

keywords​

WINDOW,FUNCTION,ROW_NUMBER