RE: [Emerald] Statistics

Emerald ( (no email) )
Wed, 1 Dec 1999 14:48:27 -0500

> Try this (althought it doesn't do the percentage, it gives the numbers):
>
> Select NASIdentifier, ConnectInfo, Count(*)
> From Calls
> Group By NASIdentifier, ConnectInfo
> Order By NASIdentifier, ConnectInfo

Close, very close to what I need. Is there a way to have it group by just
the left 5 characters of the connectinfo field though? What I'm getting is
this:

28800 LAPM/MNP5
28800 LAPM/NONE
28800 LAPM/V42BIS
28800 MNP/NONE

but I would like to see these as all one group (I only care about the
speed).

Geo.

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