Re: LIMIT number of selected rows

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

--
Sybrand Bakker, Senior Oracle DBA