|
-
Yes, and if you do a search on this forum, you can find many threads related to the topic. Here are a few...
http://www.dbasupport.com/forums/sho...?threadid=8025
http://www.dbasupport.com/forums/sho...?threadid=6830
http://www.dbasupport.com/forums/sho...?threadid=5480
...and here is the standard example I use...
SELECT
---OUTER.C1
FROM
---(
------SELECT
---------INNER.C1,
---------ROWNUM
------------AS QUERY_ROWNUM
------FROM
---------(
---------SELECT
------------C1
---------FROM
------------TABLE1
---------ORDER BY
------------C1
---------) INNER
------WHERE
---------ROWNUM < 8
---) OUTER
WHERE
---OUTER.QUERY_ROWNUM >= 4
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|