Re: Limitting number of rows returned from a select.

From: Mike K. Tyler <miket_at_kallback.com>
Date: 1996/06/17
Message-ID: <4q4aqb$o23_at_bart.kallback.com>#1/1


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 )?
  Received on Mon Jun 17 1996 - 00:00:00 CEST

Original text of this message