Re: SELECT only a few rows...

Dejanews may have several dozen answers to this, the most frequently asked question in history ( except for, maybe, what is the best OS )...

In short:
If the order of the data is not important: select * from table where rownum < 21;
If order matters:
select * from (select * from table order by whatever) where rownum < 21;

"Dieter Hoffmann" <dieter.hoffmann_at_t-online.de> wrote:

>
>Hi,
>
>in Informix or SQL Server I have s.th. like Select First 20 * From... resp.
>Select Top 20 * From... to select the first 20 rows from a specific table.
>
>Does Oracle support such a feature? If yes, can you please tell me the
>syntax.
>Thanks in advance,
>Dieter
>
>
Received on Mon May 21 2001 - 16:09:34 CDT