Article View: borland.public.interbase.sql
Article #11345Re: First Row Only
From: Craig Stuntz TeamB
Date: Fri, 22 Nov 2002 17:05
Date: Fri, 22 Nov 2002 17:05
15 lines
1611 bytes
1611 bytes
In article <3DDE525C.7A554A48@mindspring.com>, jeffovercash@mindspring.com says... > 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. > If you want one row only in earlier versions you can use MAX on the column which determines the order. -Craig -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://delphi.weblogs.com InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer
Technical Details
Message-ID:
<MPG.18482dd49976c2ab98a236@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3dde4dd0$1@newsgroups.borland.com> <3DDE525C.7A554A48@mindspring.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 114a0e,9e46d5f5a9f54bbf X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2002-11-22 09:09:36 PST From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com (but use vertexsoftware to email)> Newsgroups: borland.public.interbase.sql Subject: Re: First Row Only Date: Fri, 22 Nov 2002 12:05:11 -0500 Message-ID: <MPG.18482dd49976c2ab98a236@newsgroups.borland.com> References: <3dde4dd0$1@newsgroups.borland.com> <3DDE525C.7A554A48@mindspring.com> Organization: Vertex Systems Corporation X-Newsreader: MicroPlanet Gravity v2.60 NNTP-Posting-Host: 65.86.87.242 X-Trace: newsgroups.borland.com 1037984619 65.86.87.242 (22 Nov 2002 09:03:39 -0800) Lines: 15 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail