Re: how this query can be done?
From: LR <lrako_at_hotmail.com>
Date: 9 Apr 2002 04:54:07 -0700
Message-ID: <dcc2db96.0204090354.66ed4c00_at_posting.google.com>
Date: 9 Apr 2002 04:54:07 -0700
Message-ID: <dcc2db96.0204090354.66ed4c00_at_posting.google.com>
Have a look on your SQL course - Chapter "grouping functions" and "how to use GROUP BY clause".
> > > 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 - 13:54:07 CEST