2018-05-03 Oracle 12c / Top N rows, pagination In older versions, limiting sorted data by the number of rows had to be implemented using a nested query. This first sorted the table, and only then was it possible to filter by count. Matěj Černý