Re: Substitute for 'TOP' keyword
From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Mon, 05 Apr 2004 19:58:05 GMT
Message-ID: <hTicc.11342$J56.927_at_edtnps89>
Date: Mon, 05 Apr 2004 19:58:05 GMT
Message-ID: <hTicc.11342$J56.927_at_edtnps89>
Ale Frisman wrote:
> Hi to all
> I'm using TOP keyword in SQL Server sql statement which returns a
> specifid number of rows : "SELECT TOP 2 * from TABLE_NAME" =>
> returns first 2 rows
>
> Does anybody knows or used a simiular technique in Oracle?
> Any help greatly appreciated
>
> Alex Frisman
Not quite sure what you mean by 'first 2 rows'. Is it the first 2 in the database (remember order in the database is unknown) or is it first 2 by date or update or what?
You might want to look up the psuedocolumn 'rownum' in the docco at http://docs.oracle.com
/Hans Received on Mon Apr 05 2004 - 21:58:05 CEST