RE: [PHP-DB] Using MAX with COUNT?
| From: | Bastien Koert | Date: | Sat, 22 Jul 2006 23:57:57 +0000 |
| Subject: | RE: [PHP-DB] Using MAX with COUNT? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-42244@lists.php.net to get a copy of this message | ||
SELECT count(*) FROM
bsp_area GROUP BY boroughID
Bastien
From: Skip Evans <skip@bigskypenguin.com>
To: Php-Db <php-db@lists.php.net>
Subject: [PHP-DB] Using MAX with COUNT?
Date: Sat, 22 Jul 2006 13:48:43 -0600
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