Re: "select" simple question?

Try this:

select * from test a
where 10 > (select count(*) from test b

                      where a.rowid > b.rowid)

Alexandre Leite.
leite_alexandre_at_hotmail.com

Jack Zhu escreveu na mensagem <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.com
>
>
Received on Fri Mar 26 1999 - 07:45:17 CST