[[mightydragonlor]]

Código SQL [-]
SELECT *
  FROM ( SELECT A.*, ROWNUM row_number
           FROM (
                SELECT primera_columna, segunda_columna
                FROM mi_tabla
            ) A
          WHERE ROWNUM <= n_end_row
    )
WHERE row_number >= n_start_row;

Espero te sirva.
Saludos.