Re: "select" simple question?

I recalled: use "rownum". But when I try to select the 2nd line for using:

select * from <table_name> where rownum = 2 ;

it doesn't work. said:"no rows selected"

Why?

Jack Zhu <jackzhu_at_monmouth.com> wrote in message news:7d990t$2qr$1_at_news.monmouth.com...
>How can I use "select" to retrive first 10 rows of a table?
>
>Thanks in advance!
>
>Pls email me!
>
>jackzhu_at_monmouth.co
Received on Tue Mar 23 1999 - 17:58:23 CST