Re: How can I select several result

Are you talking about something like this:

select * from mytable where rownum < 100;

Yong Huang
yhuang_at_indigopool.com

<dewbow_at_my-deja.com> wrote in message news:8nvcg4$30b$1_at_nnrp1.deja.com...
> It's kown that we can use limit in MySQL so it's easy for us to show
> several information from select result. We can use this: select items
> from table where condition limit <start>,<records> in MySQL. How to
> realize this function in ORACLE.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Aug 25 2000 - 09:09:40 CDT