Re: Newbie question about rownum
From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Wed, 6 Mar 2002 15:12:59 -0800
Message-ID: <a667or$bdi$1_at_spiney.sierra.com>
where r between 7 and 10
Date: Wed, 6 Mar 2002 15:12:59 -0800
Message-ID: <a667or$bdi$1_at_spiney.sierra.com>
consider:
select *
from (
select rownum r, a.* from my_table a
)
where r between 7 and 10
"hwchui" <hwc33_at_hotmail.com> wrote in message
news:a65goi$4mb2_at_imsp212.netvigator.com...
> Hi
>
> I got a table with 14records, when I do select rownum, * from myTable
>
> 14 rownum numbers plus columns from myTable are returned.
> (the rownum is 1,2,3,...14)
>
>
> If I do select rownum,* from myTable where rownum < 10.
> 10 records returned
>
> but if I do select rownum, * from myTable where rownum > 10
> no record returned
>
>
> Why is that?
>
>
> Thanks in advance.
>
>
Received on Thu Mar 07 2002 - 00:12:59 CET