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

Article View: dk.edb.database

Article #15108

#15108

From: Jonas Delfs
Date: Thu, 28 Jun 2001 20:04

20 lines
1517 bytes

"Martin H�jriis Kristensen" <hoejriis@SLETDETTEiname.com> skrev i en
meddelelse news:9hfudm$2t3$1@news.inet.tele.dk...

[...]
> Med "select distinct xxx from yyy" kan jeg f�:
>
> uuu
> vvv
> zzz
>
> og det kan jeg naturligvis t�lle i skallen, men jeg m� da kunne lave et
> sql-tr�k der bare returnerer det �nskede.

SELECT COUNT(xxx) FROM yyy GROUP BY xxx

?

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

Technical Details

Message-ID: <9hg2i5$11a$1@sunsite.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.227.3.83!newsfeed1.uni2.dk!sunsite.dk!not-for-mail

References: <9hfudm$2t3$1@news.inet.tele.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:04:13 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!130.227.3.83!newsfeed1.uni2.dk!sunsite.dk!not-for-mail
From: "Jonas Delfs" <jonas@nospam.delfs.dk>
Newsgroups: dk.edb.database
Subject: Re: [mySQL] Select Count(distinct xxx) from yyy ?
Date: Thu, 28 Jun 2001 22:04:00 +0200
Organization: SunSITE.dk - Supporting Opensource Software
Lines: 22
Sender: jonas@131.165.143.165
Message-ID: <9hg2i5$11a$1@sunsite.dk>
References: <9hfudm$2t3$1@news.inet.tele.dk>
NNTP-Posting-Host: 131.165.143.165
X-Trace: sunsite.dk 993758598 1066 131.165.143.165 (28 Jun 2001 20:03:18 GMT)
X-Complaints-To: news@sunsite.dk
NNTP-Posting-Date: Thu, 28 Jun 2001 20:03: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

Reply to Parent Message