"Henry" <hxzhang_at_binary-solutions.net> wrote in message news:<IWts8.7384$h22.302123_at_news0.telusplanet.net>...
> so give me your solution please -- don't just play as if u r boss.
>
>
>
> "justme" <someq_at_rogers.com> wrote in message
> news:wIts8.27686$cN1.26838_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:%8ss8.5924$KG3.353216_at_news2.telusplanet.net...
> > > 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!
> > >
> > >
> >
> >
Henry what you will need to do is group by type (select ...... group by type)
Michael Tubuo Ngong( Sr Oracle DBA)
Received on Tue Apr 09 2002 - 07:21:05 CDT
