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

Reply via email to