Hello.

But if we modify Chris's original posting :

[B][QUOTE][i]Originally posted by chrisrlong [/i]
[B]
SELECT
--C1,
--C2
FROM
--(
--SELECT
----C1,
----C2,
----ROWNUM
------AS QUERY_ROWNUM
--FROM
----TABLE
--WHERE
----ROWNUM < Y
--/* You can add an ORDER BY here if you want */
--) T1
WHERE
--T1.QUERY_ROWNUM > X
[/B][/QUOTE]

and include Jurii's sugestions:

SELECT C1,C2

FROM
(
SELECT
--inner.C1,
--inner.C2,
--inner.QUERY_ROWNUM
FROM (SELECT C1, C2, ROWNUM AS QUERY_ROWNUM
FROM table1
ORDER BY condition
) inner
WHERE inner.QUERY_ROWNUM < N+k
) outer

WHERE outer > N


Will this be a solution?