Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: LIMIT number of selected rows
-- "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:91dt0090n1g8susbnpmqnh24nps14451jf_at_4ax.com...Received on Fri Jan 23 2004 - 23:56:46 CST
> 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
![]() |
![]() |