Re: First Row Only

Article View: borland.public.interbase.sql

Article #11401

Back to borland.public.interbase.sql Previous Next

#11401

From: Rafael Vacas
Date: Tue, 26 Nov 2002 13:17

25 lines
1615 bytes

select * from my_table
where my_field = (select max(my_field) from my_table)

... where my_field is the "column which determines the order".

Rafael
A Coru�a

"The DeerBear" <rainaple@tin.it> escribi� en el mensaje
news:3de3690d@newsgroups.borland.com...
> Craig Stuntz [TeamB] wrote:
>
> > If you want one row only in earlier versions you can use MAX on the
> > column which determines the order.
>
> May you please expand this explaination with a simple example?
>
> TIA
>
> > -Craig
>
> Andrew
>
>

Technical Details

Message-ID: <3de37412@newsgroups.borland.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!nntp2.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<3dde4dd0$1@newsgroups.borland.com> <3DDE525C.7A554A48@mindspring.com> <MPG.18482dd49976c2ab98a236@newsgroups.borland.com> <3de3690d@newsgroups.borland.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-26 05:27:11 PST
From: "Rafael Vacas" <rvacas@bit.es>
Newsgroups: borland.public.interbase.sql
References: <3dde4dd0$1@newsgroups.borland.com> <3DDE525C.7A554A48@mindspring.com> <MPG.18482dd49976c2ab98a236@newsgroups.borland.com> <3de3690d@newsgroups.borland.com>
Subject: Re: First Row Only
Date: Tue, 26 Nov 2002 14:17:40 +0100
Lines: 27
Organization: Bit7 S.L.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 213.98.123.244
Message-ID: <3de37412@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1038316562 213.98.123.244 (26 Nov 2002 05:16:02 -0800)
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!nntp2.aus1.giganews.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message