|Subject:||ROWNUM for Page selection|
|Posted by:||Daniel Paetzold (daniel.paetzo…@de.bosch.com)|
|Date:||Fri, 07 Jan 2005|
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)
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).