SELECT City, ZIP, MBRs=count(Zip)
FROM MasterAccounts
WHERE Active = 1 /* Display only "active" people) */
GROUP BY City, Zip
ORDER BY City, Zip
----- Original Message -----
From: PowerNet <psc5@powersupply.net>
To: <emerald@iea-software.com>
Sent: Tuesday, February 01, 2000 10:04 AM
Subject: [Emerald] SQL QUERY
I need a list of zip codes I service and # of users by zip.
We are using Emerald/RadiusNt with SQL 6.5
I am looking for a nice little script that will show me Town, Zip code and #
of users per.
I would be happy to see any script close also.
Thanks,
John
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart