select town, zip, count(zip) from masteraccounts group by zip,town order by
should give you what you are looking for
> -----Original Message-----
> From: PowerNet [mailto:email@example.com]
> Sent: 01 February 2000 15:04
> To: firstname.lastname@example.org
> 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.
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: