On Mon, 11 Aug 2003, gord barq 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..
Hello, How about "SELECT COUNT(DISTINCT user) FROM results"? Hope this helps. Cheers, Tan Shao Yi -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
