Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: LIMIT number of selected rows

Re: LIMIT number of selected rows

From: Burt Peltier <burttemp1ReMoVeThIs_at_bellsouth.net>
Date: Fri, 23 Jan 2004 23:56:46 -0600
Message-ID: <DLnQb.24402$DX.17066@bignews3.bellsouth.net>

-- 

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message
news:91dt0090n1g8susbnpmqnh24nps14451jf_at_4ax.com...

> On Wed, 21 Jan 2004 18:13:26 +0100, Georg Maaß <spam_at_clausmark.com>
> wrote:
>
> >Hi,
> >
> >what is the Oracle SQL syntax to limit the number of rows returned by a
> >select.
> >
> >MS-SQL supports TOP to do this:
> >
> >select TOP 1 * from stuff;
> >
> >But what is the correct syntax for Oracle to get only the first entry?
> >
> >Greetings, Georg
>
> Questions like this one should not be posted here, but looked up in
> the Oracle SQL reference manual for your version (which you don't
> mention and the answer is version dependent), available for free at
> http://tahiti.oracle.com
>
Just curious, do you have a list of valid questions we can look at to know in advance if our questions are ok for this group :) I think a valid question was asked and the answer was given by someone. So, what exactly was wrong with this?
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Jan 23 2004 - 23:56:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US