Need some help with ROWNUM

From: Gad Krosner <krosner_at_excite.com>
Date: Mon, 05 Feb 2001 15:57:56 GMT
Message-ID: <95mihu$up7$1@nnrp1.deja.com>

Hi there!

I have a query like:

SELECT * FROM ( SELECT columns
FROM tables
WHERE join conditions, including outer join ORDER BY some columns
)
WHERE ROWNUM < 26

This query works fine, giving me the 1st 25 rows sorted as specified.

Now, I want to fetch the 25 rows between the 1001st and 1025th rows. Is there a way to accomplish this by using the ROWNUM alone?

I tried ROWNUM BEWTEEN 1001 AND 1025, but that brings no rows at all, although more than 4000 rows are returned by the inner query. My ORDER BY columns aren't part of the tables' keys.

Thanks in advance for replying.

Sent via Deja.com
http://www.deja.com/ Received on Mon Feb 05 2001 - 09:57:56 CST