I use Oracle DB and query like this 

Select * from MyTable where ROWNUM > 2;

returns no result because dyanmic ROWNUM defining. In this case, if
ROWNUM = 1, row is removed from result, that for second result gets
ROWNUM = 1, and so on.



-----Original Message-----
From: Greg Normandin [mailto:gnormandin@s...] 
Sent: Thursday, August 22, 2002 10:17 PM
To: sql language
Subject: [sql_language] RE: How to return ROWNUM 100 to 200

What kind of database are you using?

Could you not just:

SELECT * FROM MyTable WHERE (RowNum > :rownum1 AND RowNum <= :rownum2);

-Greg

-----Original Message-----
From:	Andrej Virant [SMTP:andrej.virant@i...]
Sent:	Thursday, August 22, 2002 5:39 AM
To:	sql language
Subject:	[sql_language] How to return ROWNUM 100 to 200

My query need to return pages of results. Next query is OK for small
rownums, but for large numbers it starts to become slow. Please, can you
help me improve this.
 
select a.* 
from (select b.*, rownum rn
      from mytable b
      where rownum <= :rownum2)
where rn > :rownum1;

Thank you, Andrej Virant