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