Re: a select data from a table

Hi,
You are using rownum wrongly. ROWNUM is assigned to rows at the time of out put. If your condition is "rownum < 5", its OK but if the condition is "rownum Between 10 and 15", u will get nothing because 1,2,3... have not been generated and condition can't be fullfilled.

Alok

Steve McDaniels <steve.mcdaniels_at_sierra.com> wrote in message news:7uo8eo$r08$1_at_plo.sierra.com...
> select * from
> ( select rownum, A.* from worker A )
> where rownum between 10 and 12
> /
>
> Jingyan <jingyan.xu_at_tst2000.com> wrote in message
> news:YWqO3.582$7d2.14652_at_nuq-read.news.verio.net...
> > Hi,
> > 1.my a SQL statement is below.
> > select * from worker
> > where rownum between 10 and 12
> > /
> > When I run it, no rows select. in fact, worker table has 14 rows.
> > If I run it like this:
> > select * from worker
> > where rownum between 1 and 12
> > it selects 12 rows. I want to know why?
> >
> > 2. how to write a select statement to list the five oldest workers from
> the
> > worker table.
> > select * from (select * from worker order by age desc)
> > where rownum < 6;
> > above is my way, but it doesn't work on my compuer. please help me.
> > Thanks in advance,
> > Jingyan
> >
> >
> >
>
>
Received on Fri Oct 22 1999 - 14:19:12 CDT