Re: [Emerald] Total of accounts?

Josh Hillman ( (no email) )
Tue, 20 Jul 1999 17:41:29 -0400

From: Ed Miller <emiller@del.net>
> Does someone have a SQL script that can tell me how many
> accounts I have in each type of account?
> We have someone that is interested in buying our dialup accounts,
> (A new each week ;-) and I wpuld like to have a list broken
> down by type.

How's this for a basic one?:

SELECT AccountType,
Total=count(CustomerID)
FROM subaccounts
WHERE Active = 1
GROUP BY AccountType

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart