Re: problem with select

May be you want to try this way .
Select col1 from tab1 where rownum < 21
minus
select col1 from tab1 where rownum < 11

Hope this helps
- Sathish B

"Dave Fowler" <d.fowler_at_smmj.com> wrote in message news:xQzH6.285$RK.28950_at_newsread1.prod.itd.earthlink.net...
> 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 Fri May 11 2001 - 19:58:28 CDT