Re: problem with select

Ulf,
  Are 10 through 20 values in a column? Use your_column BETWEEN 10 and 20.
The rows in the table with returned with rownum 10-20 may have any value coming back un-ordered.
I'm not sure what you want to do.

"Ulf Nystrom" <Ulf.Nystrom_at_adcore.com> wrote in message news:3AE7EBED.9F62C973_at_adcore.com...
> SELECT distinct region FROM cells fetch ;
>
> How should I continue if I want to get rows 10 to 20 from the table
> cells
>
> Tanx
> --
> **************************************************************
> Ulf Nyström
> Software Developer, DBA
>
> Adcore - Digital Business Creators
> Iso Roobertinkatu 28
> FIN-00120 Helsinki
>
> Phone +358 9 742 055 82, Fax +358 9 742 055 11
> Dir. +358 9 742 055 53, Mobile +358 40 772 0082
> www.adcore.com
> **************************************************************
> **************************************************************
> Three Rings for the Elven kings under the sky,
> Seven for the Dwarf-lords in their halls of stone,
> Nine for Mortal Men, doomed to die,
> One for the Dark Lord on his Dark Throne,
> In the land of Mordor where the shadows lie,
> One Ring to rule them all,
> One Ring to find them,
> One ring to bring them all,
> and in the darkness bind them,
> In the Land of Mordor where the shadows lies.
>
> J.R.R. Tolkien
> ***************************************************************
Received on Tue May 01 2001 - 09:35:09 CDT