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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Query

Re: SQL Query

From: Andreas Michler <Andreas.Michler_at_adicom.de>
Date: Thu, 27 Jan 2000 13:28:11 +0100
Message-ID: <389039DB.1438D01B@adicom.de>


select ............ where rownum < 2

Kinna Patel wrote:

> How can I write an SQL query which will return the first record in a
> recordset. Under SQL Server 7 you can use the keyword TOP but this
> does not work under Oracle.
>
> Thanks in advance

--



ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de
Received on Thu Jan 27 2000 - 06:28:11 CST

Original text of this message

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