Re: Help with count(*)

[mos]

At 08:15 PM 8/10/2003, you wrote:
I have a table I'm using for logging purposes with a schema like:

create table results (
   user varchar(255)
   ....
);
Where user is not a unique field and I want to find out how many unique 
users there are in the table.

I want to do something like:

select count(count(*)) from results group by user;

But that doesn't work..

Any ideas?

Thanks
Try

select user, count(*) Num from results group by user

you can also sort the results by:

select user, count(*) Num from results group by user order by Num

Mike



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]