Re: Sort by bigger count(*)

> I made a query that uses count(*) > now how can i get the results sorted following the biggest count(*) result? select count(*) as score from foo group by y order by score desc may do the trick... I often have trouble with aggregates not being allowed where I want them or not being able to aggregate on all records, but only display a subset (or vice versa). -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm