return only first row

Article View: borland.public.interbase.sql

Article #229

Back to borland.public.interbase.sql Previous Next

#229

From: Isaac
Date: Sat, 14 Jun 2008 21:39

5 lines
932 bytes

Hello ,
is there another way to return only the first row in a select statement 
other than using for select and suspend ?

Thanks

Technical Details

Message-ID: <485439ea@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,28a1978876c492d6,start
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sun, 15 Jun 2008 00:39:18 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: return only first row
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.198.118
Message-ID: <485439ea@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1213479402 41.234.198.118 (14 Jun 2008 14:36:42 -0700)
Lines: 5
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!news.glorb.com!feeder.erje.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail