🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: dk.edb.database
Article #15271

Re: GROUP BY <funktion> ?

#15271
From: Lauritz Jensen
Date: Wed, 06 Jun 2001 18:47
12 lines
1352 bytes
Jonas Delfs wrote:
> 
> Kan det virkeligt passe at man ikke kan gruppere efter resultatet 
> af kaldet til en funktion?

Har du pr�vet:
SELECT felt1, felt2, SUBSTRING(dato, 1, 10) detjegvilgrupererefter
FROM min_tabel 
GROUP BY detjegvilgrupererefter

-- 
Lauritz
Technical Details
Message-ID: <3B1E7AC7.B21114A6@hotmail.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newscore.gigabell.net!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!130.225.51.30!sunsite.dk!newsrouter.euroconnect.net!news100.image.dk!news010.worldonline.dk.POSTED!not-for-mail
References: <9fltei$6ni$1@sunsite.dk>

Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,84f8aeee060e6973
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-06 11:47:27 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!newscore.gigabell.net!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!130.225.51.30!sunsite.dk!newsrouter.euroconnect.net!news100.image.dk!news010.worldonline.dk.POSTED!not-for-mail
Message-ID: <3B1E7AC7.B21114A6@hotmail.com>
From: Lauritz Jensen <lauritz2@hotmail.com>
Organization: -
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: dk.edb.database
Subject: Re: GROUP BY <funktion> ?
References: <9fltei$6ni$1@sunsite.dk>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 12
Date: Wed, 06 Jun 2001 20:47:35 +0200
NNTP-Posting-Host: 213.237.43.17
X-Complaints-To: news-abuse@wol.dk
X-Trace: news010.worldonline.dk 991853246 213.237.43.17 (Wed, 06 Jun 2001 20:47:26 MET DST)
NNTP-Posting-Date: Wed, 06 Jun 2001 20:47:26 MET DST