Re: Please help with SQL

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 - 09:55:50 CST