-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Skip Evans wrote:
I have a table like this:
boroughIDArea
=
1Chelsea
1East Village
1West Village
1So Ho
2Prospect Park
2Brooklyn Heights
3Prospect Heights
What
SELECT count( * )
FROM `bsp_area`
GROUP BY boroughID ORDER BY count(*) DESC LIMIT 1
Bastien
From: [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] Using MAX with COUNT?
Date: Sat, 22 Jul 2006 20:25:57 -0600 (MDT)
Hi
Why don't you use a where instead of a group function?
On 7/22/06, Skip Evans [EMAIL PROTECTED] wrote:
Hey all,
I have a table like this:
boroughID Area
=
1 Chelsea
1 East Village
1 West Village
1 So Ho
2
SELECT count(*) FROM `bsp_area` GROUP BY boroughID
Bastien
From: Skip Evans [EMAIL PROTECTED]
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