Here is a link to a previous discussion on the topic.

[url]http://www.dbasupport.com/forums/showthread.php?threadid=5480[/url]

Yes, you want to use ROWNUM, but not really sure what bensr was trying to show.

Here is the example from the thread:

SELECT
---OUTER.C1
FROM
---(
------SELECT
---------INNER.C1,
---------ROWNUM
------------AS QUERY_ROWNUM
------FROM
---------(
---------SELECT
------------C1
---------FROM
------------TABLE1
---------ORDER BY
------------C1
---------) INNER
------WHERE
---------ROWNUM (LESS THAN) 8
---) OUTER
WHERE
---OUTER.QUERY_ROWNUM >= 4

HTH,

- Chris