Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Please help with SQL

Re: Please help with SQL

From: Alan <alanshein_at_erols.com>
Date: Mon, 18 Mar 2002 11:21:24 -0500
Message-ID: <a7545j$io84u$1@ID-114862.news.dfncis.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US