select zip, count(zip) from masteraccounts
group by zip
That will sort them nicely.
Duane.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Phil Taylor
Sent: Tuesday, February 01, 2000 10:15 AM
To: 'emerald@iea-software.com'
Subject: RE: [Emerald] SQL QUERY
Hi,
select town, zip, count(zip) from masteraccounts group by zip,town order by
zip
should give you what you are looking for
Cheers
Phil
> -----Original Message-----
> From: PowerNet [mailto:psc5@powersupply.net]
> Sent: 01 February 2000 15:04
> To: emerald@iea-software.com
> 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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart