Subject | FB30 question about row_number |
---|---|
Author | liviuslivius |
Post date | 2013-08-07T07:43:32Z |
Hi,
i have question about row_number window function
what it numerate records processed or records in retrieval order?
i have query where result is like this
Dense_rank Rank Row_Number
1 1 2
1 1 4
1 1 3
1 1 1
......
should i do order by row_number column to get it in 1, 2, 3, 4.. or this an error?
regards,
Karol Bieniaszewski
[Non-text portions of this message have been removed]
i have question about row_number window function
what it numerate records processed or records in retrieval order?
i have query where result is like this
Dense_rank Rank Row_Number
1 1 2
1 1 4
1 1 3
1 1 1
......
should i do order by row_number column to get it in 1, 2, 3, 4.. or this an error?
regards,
Karol Bieniaszewski
[Non-text portions of this message have been removed]