Re: ROWNUM for Page selection

Giganews Newsgroups
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
PSEUDO-column.

--
Noel

Replies

In response to

ROWNUM for Page selection posted by Daniel Paetzold on Fri, 07 Jan 2005