Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SELECT only a few rows...
In article <9ebttm$4sk$06$1_at_news.t-online.com>, Dieter Hoffmann
<dieter.hoffmann_at_t-online.de> writes:
>
>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?
Not exactly (that I know of), but it's easy to fake.
select species
from turtle
where RowNum <= 20
RowNum is a pseudo-column that always refers to a virtual row number within the results of your query.
>Thanks in advance,
>Dieter
Bitte schoen!
- Catherine