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:
-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 Height
SELECT count(*) FROM `bsp_area` GROUP BY boroughID
Bastien
From: Skip Evans <[EMAIL PROTECTED]>
To: Php-Db
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
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