You have many different rows for the same FISCAL_YEAR and Oracle can order rows however it wants as long as all rows with FISCAL_YEAR 2016 come before FISCAL_YEAR 2015. If you additionally ORDER BY the ID, you get deterministic behavior and the pagination should work as expected. |