GROUP BY <funktion> ?

Article View: dk.edb.database

Article #15270

#15270

From: Jonas Delfs
Date: Wed, 06 Jun 2001 18:41

14 lines
1531 bytes

Hej

Kan det virkeligt passe at man ikke kan gruppere efter resultatet af kaldet
til en funktion?
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.
Det er da klart den letteste m�de at gruppere efter en bestemt sammens�tning
at indholdet af to kolonner ?

--
Mvh. Jonas Delfs, http://delfs.dk

Technical Details

Message-ID: <9fltei$6ni$1@sunsite.dk>

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!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,84f8aeee060e6973,start
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-06 11:40:34 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!not-for-mail
From: "Jonas Delfs" <nospam@delfs.dk>
Newsgroups: dk.edb.database
Subject: GROUP BY <funktion> ?
Date: Wed, 6 Jun 2001 20:41:48 +0200
Organization: SunSITE.dk - Supporting Opensource Software
Lines: 16
Sender: jonas@131.165.143.165
Message-ID: <9fltei$6ni$1@sunsite.dk>
NNTP-Posting-Host: 131.165.143.165
X-Trace: sunsite.dk 991852818 6898 131.165.143.165 (6 Jun 2001 18:40:18 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Wed, 6 Jun 2001 18:40:18 +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