Re: Limitting number of rows returned from a select.

In article <4q4aqb$o23_at_bart.kallback.com> Mike K. Tyler <miket_at_kallback.com> wrote:
> In article <4prrtq$q7d_at_kodak.rdcs.Kodak.COM>,
> kp40.v922034_at_kodako.kodak.com (Bryan Grenn) wrote:
> This is the deal:
> 'Select * from (table name) where rownum < 200'
>
>
> miket_at_kallback.com
> >
> >All,
> >
> > We have a customer who is converting from RDB to Oracle. In
> >RDB they can limit the select to retrieve say the first 200
> >rows through part of the select clause.
> >
> >Is there any way to do this in an Oracle Select clause,
> >
> > and
> >In what versions is this available (if it is )?
>

Try this:

     Select * from <table_name> where rownum < 201;

to return the first 200 rows; Received on Fri Jun 21 1996 - 00:00:00 CEST