I am not real good with SQL yet.
*********** REPLY SEPARATOR ***********
On 2/1/00, at 4:15 PM, Phil Taylor wrote:
>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