Subject | Re: [ib-support] Selecting only the first row |
---|---|
Author | Helen Borrie |
Post date | 2001-02-07T12:31:58Z |
At 02:16 PM 07-02-01 +0200, you wrote:
HB
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>Hi,You already asked this question. :)
>
>I need to retrieve the first row of a table. Using Microsoft SQL Server 7.0,
>this can be done with the following SET statement...
>
>SET ROWCOUNT 1
>SELECT * FROM EMPLOYEE
>
>How do I do something similar with IB?
HB
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________