Article View: dk.edb.database
Article #15204Re: + x * 31536000
From: Henrik Hansen
Date: Mon, 09 Jul 2001 10:49
Date: Mon, 09 Jul 2001 10:49
22 lines
1410 bytes
1410 bytes
Thomas Lundstr�m <thomas-l@mail.com> wrote:
> Jonas Delfs wrote:
>>
>> > Hvordan skriver man, hvis man kan:
>> >
>> > SELECT felt WHERE felt = tal1 + x * tal2
>>
>> Hvor man skriver det?
>> (...)
>
> Du misforst�r mig!
> Jeg vil med een SQL querry finde alle felter som opfylder
> 'felt = tal1 + x * tal2' hvor X tilh�rer {..., -3, -2, -1, 0, 1, 2, 3,
> ...}
select felt from table where x in(1,2,3,4,5,6) and felt = tal1 + x * tal2
AFAIK
--
Henrik Hansen
Technical Details
Message-ID:
<uwv5ifkci.fsf@mailserver.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.tele.dk!not-for-mailReferences:
<3B487A6C.112CCF35@mail.com> <9ia385$gi7$1@sunsite.dk> <3B49873B.DE1DC0F5@mail.com>Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,c4586e5e5189cd3b X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-07-09 03:47:55 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.97.206.81!kinglear.mobilixnet.dk!news.tele.dk!not-for-mail Newsgroups: dk.edb.database Subject: Re: + x * 31536000 References: <3B487A6C.112CCF35@mail.com> <9ia385$gi7$1@sunsite.dk> <3B49873B.DE1DC0F5@mail.com> From: Henrik Hansen <hh@mailserver.dk> Date: Mon, 09 Jul 2001 12:49:33 +0200 Message-ID: <uwv5ifkci.fsf@mailserver.dk> User-Agent: Gnus/5.090004 (Oort Gnus v0.04) Emacs/20.7 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Lines: 22 Organization: TDC Internet NNTP-Posting-Host: 193.88.249.39 X-Trace: 994675674 dread04.news.tele.dk 307 193.88.249.39 X-Complaints-To: abuse@post.tele.dk