Article View: dk.edb.database
Article #15271Re: GROUP BY <funktion> ?
From: Lauritz Jensen
Date: Wed, 06 Jun 2001 18:47
Date: Wed, 06 Jun 2001 18:47
12 lines
1352 bytes
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-mailReferences:
<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