Re: First Row Only

Article View: borland.public.interbase.sql

Article #11344

Back to borland.public.interbase.sql Previous Next

#11344

From: Jeff Overcash (TeamB)
Date: Fri, 22 Nov 2002 15:50

22 lines
1761 bytes

IB 6.5 and higher just use ROWS 1.  Earlier versions you can either write a SP
that exits after the first row is returned.

Tracy McClarnon wrote:
> 
> Hello,
> 
> I'm sure this has been asked before, but I am unable to locate it here in
> the newsgroups. How can I retrieve only the first row in a select staement?
> 
> Thank you,
> 
> Tracy McClarnon

-- 
Jeff Overcash (TeamB) 
      (Please do not email me directly unless  asked. Thank You) 
Maybe it was infatuation or the thrill of the chase.
Maybe you were always beyond my reach and my heart was playing safe.
But was that love in your eye I saw or the reflection of mine?
Give me time, won't you give me that time!
Welcome back to the circus.            (Fish)

Technical Details

Message-ID: <3DDE525C.7A554A48@mindspring.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!logbridge.uoregon.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3dde4dd0$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,9e46d5f5a9f54bbf
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-11-22 08:08:01 PST
Message-ID: <3DDE525C.7A554A48@mindspring.com>
Date: Fri, 22 Nov 2002 10:50:52 -0500
From: "Jeff Overcash (TeamB)" <jeffovercash@mindspring.com>
Organization: TeamB
X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: First Row Only
References: <3dde4dd0$1@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 66.32.65.177
X-Trace: newsgroups.borland.com 1037980131 66.32.65.177 (22 Nov 2002 07:48:51 -0800)
Lines: 22
X-Authenticated-User: overcash
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!logbridge.uoregon.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message