Newbie question about rownum
From: hwchui <hwc33_at_hotmail.com>
Date: Thu, 7 Mar 2002 00:40:26 +0800
Message-ID: <a65goi$4mb2_at_imsp212.netvigator.com>
Date: Thu, 7 Mar 2002 00:40:26 +0800
Message-ID: <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.