Subject FB30 question about row_number
Author liviuslivius
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]