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

Article View: dk.edb.database

Article #15107

#15107

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

30 lines
1658 bytes

Hejsa

Jeg har en tabel yyy med en kolonne xxx
indholdet er:

uuu
uuu
vvv
vvv
vvv
zzz

Jeg vil gerne vide hvor mange forskellige v�rdier der er.
Alts� 3 i n�vnte eksempel.

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.

--
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: <9hfudm$2t3$1@news.inet.tele.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!t-online.de!news.tele.dk!TDC-Europe.POSTED!fw1.inet.tele.dk!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,835ca28d5860df6,start
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-06-28 11:52:42 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!t-online.de!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: [mySQL] Select Count(distinct xxx) from yyy ?
Date: Thu, 28 Jun 2001 20:53:52 +0200
Organization: Posted through some European Outpost of TDC Internet A/S
Lines: 31
Message-ID: <9hfudm$2t3$1@news.inet.tele.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 993754358 2979 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