I have a table like below in MS SQL. I reach the Row Number values with using ROW_NUMBER Partition function. But this was not the result I wanted to achieve.
RowNumber | Value |
---|---|
1 | A |
2 | A |
3 | A |
1 | B |
2 | B |
1 | C |
1 | D |
I want to reach this table
RowNumber | Value |
---|---|
1 | A |
1 | A |
1 | A |
2 | B |
2 | B |
3 | C |
4 | D |
How can I do it, do you have a function suggestion?