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
