Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SELECT only a few rows...

Re: SELECT only a few rows...

From: <catherine_devlin_at_purpleturtle.com>
Date: 22 May 2001 18:44:15 GMT
Message-ID: <9eec1v$aqu$1@news.netmar.com>

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

Received on Tue May 22 2001 - 13:44:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US