Limitting number of rows returned from a select.

From: Bryan Grenn <kp40.v922034_at_kodako.kodak.com>
Date: 1996/06/14
Message-ID: <4prrtq$q7d_at_kodak.rdcs.Kodak.COM>#1/1

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 Fri Jun 14 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: elhuilli: "Re: Passing parameter from form 4.5 to report 2.5"
Previous message: Ole Christian Meldahl: "Generating tables with relationships in arc and part of primary key, bug?"
Next in thread: Mike K. Tyler: "Re: Limitting number of rows returned from a select."
Reply: Naresh Ramamurti: "Re: Limitting number of rows returned from a select."
Reply: Mike K. Tyler: "Re: Limitting number of rows returned from a select."
Maybe reply: Thomas J. Kyte: "Re: Limitting number of rows returned from a select."
Maybe reply: -: "Re: Limitting number of rows returned from a select."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message