From: Scott Liu
Date: March 12 1999 7:34pm
Subject: Re: select count distinct
List-Archive: http://lists.mysql.com/mysql/141
Message-Id: <36E96C62.AA3EE185@tapestry.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



ChinaConnect wrote:

> Hi,
> In mysql, it doesn't look like you can do this:
> select count(distinct id) from sometable.
>
> If this is true, how would I count the number of times distinct ids occur?
>
>

I noticed that, too. What I did is to "select id from sometable" and then
count the
distinct id in the application program. Can anyone give us a better way to do
this?

Scott

> G
>
> ---------------------------------------------------------------------
> To request this thread, e-mail mysql-thread61@stripped
>
> To unsubscribe, e-mail the address in the List-Unsubscribe header.
> For additional commands, e-mail: mysql-help@stripped

Scott Liu
Software Developer
831 460 4300
.....................................................................

TAPESTRY.NET - On Target, Online Recruiting
111 Mission St. Santa Cruz, CA 95060

Visit our web sites at:
http://www.tapestry.net
http://www.asia-net.com      Bilingual Professionals
http://www.developers.net   Software Developers