Description | The |
Syntax | ROW_NUMBER() |
Output | integer |
Example
ROW_NUMBER() Over (Partition by Group
Order by Value
)
ID | Group | Value | ROW_NUMBER |
1 | A | 10 | 1 |
2 | A | 20 | 3 |
3 | A | 15 | 2 |
4 | B | 30 | 1 |
5 | B | 40 | 2 |
Description | The |
Syntax | ROW_NUMBER() |
Output | integer |
ROW_NUMBER() Over (Partition by Group
Order by Value
)
ID | Group | Value | ROW_NUMBER |
1 | A | 10 | 1 |
2 | A | 20 | 3 |
3 | A | 15 | 2 |
4 | B | 30 | 1 |
5 | B | 40 | 2 |