Re: LIMIT number of selected rows

Georg Maaß 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

What is the definition if 'first entry'?

(AFAIK: Neither the SQL language nor relational theory has any sense of order; Both explicitly state that the retrieval order is independent of insertion order and any correlation is coincidental.) Received on Sat Jan 24 2004 - 15:28:11 CST