Re: Newbie question about rownum

"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.
Rownum is a pseudo column that acts as a counter starting with 1. The first row returned from a query is always = 1, the second = 2 etc. This means for a query with ANY results you can only apply a limiting factor such as < Received on Thu Mar 07 2002 - 00:06:23 CET