Article View: dk.edb.database
Article #15272Re: GROUP BY <funktion> ?
From: Andreas Fr�sting
Date: Wed, 06 Jun 2001 18:47
Date: Wed, 06 Jun 2001 18:47
12 lines
1417 bytes
1417 bytes
>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 ;) :wq! /andreas
Technical Details
Message-ID:
<5lusht0s50ghiim6vubf8om2pjtbcpdvpr@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!opentransit.net!wanadoo.fr!proxad.net!fr.usenet-edu.net!usenet-edu.net!news.tele.dk!212.242.40.196!news.cybercity.dk!thor.tn8or.com!nobodyReferences:
<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:55:30 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!opentransit.net!wanadoo.fr!proxad.net!fr.usenet-edu.net!usenet-edu.net!news.tele.dk!212.242.40.196!news.cybercity.dk!thor.tn8or.com!nobody From: Andreas Fr�sting <smoelf@phpwizard.dk> Newsgroups: dk.edb.database Subject: Re: GROUP BY <funktion> ? Date: Wed, 06 Jun 2001 20:47:59 +0200 Organization: CyberCity Internet Lines: 12 Message-ID: <5lusht0s50ghiim6vubf8om2pjtbcpdvpr@4ax.com> References: <9fltei$6ni$1@sunsite.dk> NNTP-Posting-Host: port13.ds1-taa.adsl.cybercity.dk Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.cybercity.dk 991853722 74805 212.242.189.78 (6 Jun 2001 18:55:22 GMT) X-Complaints-To: abuse@cybercity.dk NNTP-Posting-Date: Wed, 6 Jun 2001 18:55:22 +0000 (UTC) X-Newsreader: Forte Agent 1.8/32.548