before 12c § SELECT * FROM (SELECT * FROM DUAL ORDER BY COLUMN_NAME) WHERE ROWNUM>= ? AND ROWNUM<= ? after 12c § SELECT * FROM DUAL ORDER BY COLUMN_NAME OFFSET ? ROWS FETCH NEXT ? ROWS ONLY