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 Thu Oct 21 1999 - 18:40:36 CDT
