Re: how this can be done?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Wed, 10 Apr 2002 09:14:12 GMT
Message-ID: <3cb401f3.3963809@news.jaapwvandijk.myweb.nl>

In this way he won't see the types for which there are no people.

Jaap.

On Tue, 09 Apr 2002 00:14:30 -0700, Praveen <pmohanan_at_directvinternet.com> wrote:

>select type ||':', count(*) || ' people'
>from <table>
>group by type;
>
>
>Hope this helps.
>
>Henry wrote:
>
>> 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!
>
>--
>
>
>Regards,
>
>Praveen
>
>
Received on Wed Apr 10 2002 - 04:14:12 CDT