ROWNUM for Page selection

From: Daniel Paetzold <daniel.paetzold_at_de.bosch.com>
Date: Fri, 07 Jan 2005 12:44:55 +0100
Message-ID: <crlsno$5kg$1@ns2.fe.internet.bosch.com>

Hello and happy new year NG ;),

is there any better solution for the following query

select a from (select a, ROWNUM "ROW_SUB" from t where ROWNUM<=200) where "ROW_SUB">100;

to select only rows 101 to 200 from the tabledata?

"better" for me would be:
A. faster processing for Oracle or/and
B. avoiding the sub-query

Does anybody knows any way to do this with all ansi-sql-compatible databases (i don't think that rownum is part of ansi-sql)?

The query will be executed quite often and i'd like to speed it up as much as possible (without thinking about the structure of the data for now).

Regards,
Daniel Received on Fri Jan 07 2005 - 05:44:55 CST