Both results are correct. The difference occurs, because the a calculation views rank node uses internally the ROW_NUMBER window function instead of the RANK window function you have used in your SQL statement.
You can verify this, by doing a select on the calculation view and analyze it using the Explain Plan or PlanViz functionality.
Regards,
Florian
Add comment