|Subject:||Re: ROWNUM for Page selection|
|Posted by:||Noel (tome…@s_o_f_t_m_a_n.pl)|
|Date:||Fri, 07 Jan 2005|
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
ROWNUM for Page selection posted by Daniel Paetzold on Fri, 07 Jan 2005