Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help with SQL
You have to ask?
"damorgan" <damorgan_at_exesolutions.com> wrote in message
news:3C960E11.A2E71817_at_exesolutions.com...
> Is this a class project?
>
> Daniel Morgan
>
>
>
> Yuri Rshtuniq wrote:
>
> > Hi !
> >
> > I have a table of employees and their hiredates
> >
> > EMP HIREDATE
> > ------ ------------
> > AAA 10-AUG-82
> > BBB 12-OCT-82
> > CCC 20-JUN-89
> > DDD 12-OCT-82
> > EEE 20-JUN-89
> > FFF 12-OCT-82
> > GGG 10-AUG-82
> > HHH 13-APR-95
> >
> > I want to group employees with the same hiredates and ignore others.
Each
> > "group" hiredate will become the column title:
> >
> > 10-AUG-82 12-OCT-82 20-JUN-89
> > ------------- ------------- ------------
> > AAA BBB CCC
> > GGG DDD EEE
> > FFF
> >
> > Thanks in advance...
>
Received on Mon Mar 18 2002 - 10:21:24 CST