Re: Using MAX with COUNT?

Why don't you use a where instead of a group function? On 7/22/06, Skip Evans <skip@bigskypenguin.com> wrote:

Hey all, I have a table like this:

boroughID       Area
=========       ====
1               Chelsea
1               East Village
1               West Village
1               So Ho
2               Prospect Park
2               Brooklyn Heights
3               Prospect Heights

What I want to know is which boroughID has the most area's assocated with it, and how many. So I tried this: SELECT max(count(*)) FROM bsp_area GROUP BY boroughID ...and got an "Invalid use of group function" error. Anyone think of another way to do this in a single SQL statement, or some other simple method? -- Skip Evans Big Sky Penguin, LLC 61 W Broadway Butte, Montana 59701 406-782-2240 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- Dave W