Re: ROWNUM for Page selection

Dnia 1/7/2005 12:44 PM, Użytkownik Daniel Paetzold napisał:

> 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?

Yes, add primary key to table, then fill it from sequence then choose rows from 101 to 200 using this command.

There is no "rows 101 to 200" in whole Oracle, and ROWNUM is temporary PSEUDO-column.

-- 
Noel