Subject | Select first row |
---|---|
Author | Don Schoeman |
Post date | 2001-02-07T08:47:13Z |
Hi,
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?
Best Regards,
Don Schoeman
__________________________________________________________________
Don Schoeman | Systems Engineer
Cellpoint SA (Pty) Ltd. | GSM data communication solutions
http://www.cellpt.co.za | http://www.cellpt.com
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?
Best Regards,
Don Schoeman
__________________________________________________________________
Don Schoeman | Systems Engineer
Cellpoint SA (Pty) Ltd. | GSM data communication solutions
http://www.cellpt.co.za | http://www.cellpt.com