how to find max value of query using group by

[dognobbler]

When I run the following query

select count( username) as count, username
from friends
where status="validated"
group by username
order by count;

it gives me a list of each username in the and how many times it appears in the friends table

Can anyone tell me how to rewrite this query so that it tells me which username appeared the most times in the friends table.

Thanks

Andy

 

[sleipnir214]

select
username, count(username) as usercount from
foo
group by
username
order by
usercount desc
limit
1


is one way.



Want the best answers? Ask the best questions!

TANSTAAFL!!