Re: [mySQL] Select Count(distinct xxx) from yyy ?

Article View: dk.edb.database

Article #15109

#15109

From: Martin H�jriis Kristensen
Date: Thu, 28 Jun 2001 20:28

24 lines
1615 bytes

"Jonas Delfs" <jonas@nospam.delfs.dk> skrev i en meddelelse
news:9hg2i5$11a$1@sunsite.dk...
> SELECT COUNT(xxx) FROM yyy GROUP BY xxx

Desv�rre nej.
Den returnerer
2
3
1

svarende til
uuu 2
vvv 3
zzz 1

Jeg skal bruge en streng der returnerer eet tal, som fx "Count(*) from yyy"
g�r det.

--
Med Venlig Hilsen

Martin H�jriis Kristensen
Svar bedes baseret p� RFC1855
Jeg repr�senterer med denne udtalelse mig selv og ikke TDC Internet

Technical Details

Message-ID: <9hg3uh$3n6$1@news.inet.tele.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.74.64.35!colt.net!news.tele.dk!TDC-Europe.POSTED!fw1.inet.tele.dk!not-for-mail

References: <9hfudm$2t3$1@news.inet.tele.dk> <9hg2i5$11a$1@sunsite.dk>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,835ca28d5860df6
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-28 13:27:02 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.74.64.35!colt.net!news.tele.dk!TDC-Europe.POSTED!fw1.inet.tele.dk!not-for-mail
From: "Martin H�jriis Kristensen" <hoejriis@SLETDETTEiname.com>
Newsgroups: dk.edb.database
Subject: Re: [mySQL] Select Count(distinct xxx) from yyy ?
Date: Thu, 28 Jun 2001 22:28:10 +0200
Organization: Posted through some European Outpost of TDC Internet A/S
Lines: 25
Message-ID: <9hg3uh$3n6$1@news.inet.tele.dk>
References: <9hfudm$2t3$1@news.inet.tele.dk> <9hg2i5$11a$1@sunsite.dk>
NNTP-Posting-Host: fw1.inet.tele.dk
Mime-Version: 1.0
Content-Type: text/plain;
 charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
X-Trace: news.inet.tele.dk 993760017 3814 193.163.158.4
X-Complaints-To: the appropriate department of the poster's provider
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700

Reply to Parent Message