Article View: dk.edb.database
Article #15114Re: [mySQL] Select Count(distinct xxx) from yyy ?
From: Morten Breum Mikkelsen
Date: Fri, 29 Jun 2001 07:02
Date: Fri, 29 Jun 2001 07:02
9 lines
1358 bytes
1358 bytes
Jeg ved ikke om man kan SELECT COUNT(distinct xxx) FROM yyy; men ellers kan man vel SELECT COUNT(antal) FROM (SELECT DISTINCT xxx AS antal FROM yyy); (Er subselects ikke i mySql?) -- Morten - http://www.sickhumor.dk/
Technical Details
Message-ID:
<9hh8vj$o04$1@sunsite.dk>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mailReferences:
<9hfudm$2t3$1@news.inet.tele.dk> <9hg2i5$11a$1@sunsite.dk> <9hg3uh$3n6$1@news.inet.tele.dk>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcdf9,835ca28d5860df6 X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-06-28 23:59:46 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail From: "Morten Breum Mikkelsen" <mbreum@odense.kollegionet.dk> Newsgroups: dk.edb.database Subject: Re: [mySQL] Select Count(distinct xxx) from yyy ? Date: Fri, 29 Jun 2001 09:02:21 +0200 Organization: SunSITE.dk - Supporting Opensource Software Lines: 9 Sender: mbreum@visl.hum.ou.dk Message-ID: <9hh8vj$o04$1@sunsite.dk> References: <9hfudm$2t3$1@news.inet.tele.dk> <9hg2i5$11a$1@sunsite.dk> <9hg3uh$3n6$1@news.inet.tele.dk> NNTP-Posting-Host: visl.hum.ou.dk Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: sunsite.dk 993797939 24580 130.225.141.86 (29 Jun 2001 06:58:59 GMT) X-Complaints-To: news@sunsite.dk NNTP-Posting-Date: Fri, 29 Jun 2001 06:58:59 +0000 (UTC) X-Authenticated: mbreum@odense.kollegienet.dk User-Agent: Pan/0.9.6 (Unix)