Re: Need some help with ROWNUM

Gad,

How about ...

SELECT * FROM
(

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

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

hth
Steve Blomeley Received on Mon Feb 05 2001 - 11:16:44 CST