Re: "select" simple question?

Hi,

Don't recall the technical reasons why, but the only way that rownum can be used is with the '<' operator.

So, 'select * from <table name> where rownum < 11' will retrieve the first 10 rows.

Manmohan Mann

Jack Zhu wrote:
>
> How can I use "select" to retrive first 10 rows of a table?
>
> Thanks in advance!
>
> Pls email me!
>
> jackzhu_at_monmouth.com
Received on Tue Mar 23 1999 - 18:45:38 CST