Article View: dk.edb.database
Article #15273Re: GROUP BY <funktion> ?
From: Jonas Delfs
Date: Wed, 06 Jun 2001 19:03
Date: Wed, 06 Jun 2001 19:03
23 lines
1838 bytes
1838 bytes
"Andreas Fr�sting" <smoelf@phpwizard.dk> skrev i en meddelelse news:5lusht0s50ghiim6vubf8om2pjtbcpdvpr@4ax.com... > >Eks.: SELECT * FROM min_tabel GROUP BY SUBSTRING(dato, 1, 10) eller SELECT * > >FROM min_tabel GROUP BY CONCAT(dato,'-',et_felt) > > > >Jeg kan ikke f� det til at virke, eller finde det i manualen - men det VILLE > >da v�re genialt hvis man kunne. > > SELECT SUBSTRING (dato,1,10) as hmm FROM table GROUP BY hmm > > Plejer da at virke ;) Ja, selvf�lgeligt. Jeg gider ikke fort�lle hvordan jeg dyyybest inde godt vidste det, da det lyder som en d�rlig undskyldning :)) Tak til jer begge! (som i �vrigt svarede p� samme sekund) -- Mvh. Jonas Delfs, http://delfs.dk
Technical Details
Message-ID:
<9flumr$a36$1@sunsite.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.home.com!news.home.com!newshub1.nl.home.com!news.nl.home.com!sunsite.dk!not-for-mailReferences:
<9fltei$6ni$1@sunsite.dk> <5lusht0s50ghiim6vubf8om2pjtbcpdvpr@4ax.com>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 12:02:01 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.home.com!news.home.com!newshub1.nl.home.com!news.nl.home.com!sunsite.dk!not-for-mail From: "Jonas Delfs" <nospam@delfs.dk> Newsgroups: dk.edb.database Subject: Re: GROUP BY <funktion> ? Date: Wed, 6 Jun 2001 21:03:17 +0200 Organization: SunSITE.dk - Supporting Opensource Software Lines: 25 Sender: jonas@131.165.143.165 Message-ID: <9flumr$a36$1@sunsite.dk> References: <9fltei$6ni$1@sunsite.dk> <5lusht0s50ghiim6vubf8om2pjtbcpdvpr@4ax.com> NNTP-Posting-Host: 131.165.143.165 X-Trace: sunsite.dk 991854107 10342 131.165.143.165 (6 Jun 2001 19:01:47 GMT) X-Complaints-To: news@sunsite.dk NNTP-Posting-Date: Wed, 6 Jun 2001 19:01:47 +0000 (UTC) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-Authenticated: jonas@delfs.dk