Please help with SQL

From: Yuri Rshtuniq <yuri_rshtuniq_at_1hotmail.com>
Date: Mon, 18 Mar 2002 13:20:13 +0200
Message-ID: <a74ilt$53r$1@news.inter.net.il>

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 - 05:20:13 CST