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
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