Re: how this query can be done?

From: Henry <hxzhang_at_binary-solutions.net>
Date: Tue, 09 Apr 2002 04:19:35 GMT
Message-ID: <rZts8.7406$h22.302314_at_news0.telusplanet.net>


hey, big mouth, shut up if you don't know the answer

"justme" <someq_at_rogers.com> wrote in message news:lIts8.27684$cN1.10460_at_news01.bloor.is.net.cable.rogers.com...
> I suspect your a student, if you are a employee , I would fire you
> "Henry" <hxzhang_at_binary-solutions.net> wrote in message
> news:z8ss8.5923$KG3.353551_at_news2.telusplanet.net...
> > I have a table with different employees. It is known that employees may
> > fall into the following categories:
> >
> > { type0, type1, type2, type3, ...type 100, ....}
> >
> > however, there could be no employ for a certain type at all.
> >
> > My boss wants an query that list all types with its number of
 employees.
> > and the sql result will be like:
> >
> > type0 : 5 people
> > type1 : 1 people
> > type2 : 0 people
> > ...
> >
> >
> > how can i accomplish this?
> > thanx a lot!
> >
> >
>
>
Received on Tue Apr 09 2002 - 06:19:35 CEST

Original text of this message