Re: Is there something equivalent to a "Find nearest" in SQL, IB6.0.2.0?

Article View: borland.public.interbase.opensource

Article #253

Back to borland.public.interbase.opensource Previous Next

#253

From: Red
Date: Wed, 18 May 2005 14:16

13 lines
1280 bytes

Dan, there's no "rows" qualifier for the SELECT command in IB 6.0.2.0

...hmm...


>
>Select   * from table1 where fld_1 <=2.99999999 order by fld_1 desc rows 1
>
>and
>
>Select * from table1 where fld_1>=2.9999999 order by fld_1 asc rows 1
>
>Dan

Technical Details

Message-ID: <428b4e07.133176667@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References:

<428a5b61.71058216@newsgroups.borland.com> <428a60f3$1@newsgroups.borland.com> <428a630b.73020187@newsgroups.borland.com> <428a6d3e$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 106772,8899b8536c5e6b11
X-Google-Attributes: gid106772,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: nospam_kandw321@icrossroads.com (Red)
Newsgroups: borland.public.interbase.opensource
Subject: Re: Is there something equivalent to a "Find nearest" in SQL, IB6.0.2.0?
Date: Wed, 18 May 2005 14:16:46 GMT
Message-ID: <428b4e07.133176667@newsgroups.borland.com>
References: <428a5b61.71058216@newsgroups.borland.com> <428a60f3$1@newsgroups.borland.com> <428a630b.73020187@newsgroups.borland.com> <428a6d3e$1@newsgroups.borland.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: 142.179.164.127
X-Trace: newsgroups.borland.com 1116425794 142.179.164.127 (18 May 2005 07:16:34 -0700)
Lines: 18
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!border1.nntp.dca.giganews.com!nntp.giganews.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!news-in.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message