Re: [Emerald] Statistics

Dale E. Reed Jr. ( (no email) )
Wed, 01 Dec 1999 12:27:04 -0800

Emerald wrote:
>
> > 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).

Maybe something like:

Select NASIdentifier, Speed=convert(int,ConnectInfo), Count(*)