Re: [Emerald] SQL QUERY

• Messages sorted by: [ date ][ thread ][ subject ][ author ]
• Previous message: PowerNet: "RE: [Emerald] SQL QUERY"
• Next message: Dale E. Reed Jr.: "Re: [Emerald] changing pay periods"
• Maybe in reply to: PowerNet: "[Emerald] SQL QUERY"
• Next in thread: Kenneth Gustav Eitenmiller Jr: "Re: [Emerald] SQL QUERY"

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

• Previous message: PowerNet: "RE: [Emerald] SQL QUERY"
• Next message: Dale E. Reed Jr.: "Re: [Emerald] changing pay periods"
• Maybe in reply to: PowerNet: "[Emerald] SQL QUERY"
• Next in thread: Kenneth Gustav Eitenmiller Jr: "Re: [Emerald] SQL QUERY"