Please help with SQL

From: Lucy Kas <noad_at_no.com>
Date: Sun, 17 Mar 2002 10:48:23 +0200
Message-ID: <3c94598d@news.012.net.il>

I have a table of employees and their hiredates.

NAME        HIREDATE
--------        ---------------
Smith        10_AUG_82
Beaver      10_AUG_82
O'Nil          03_JUN_85
Martens    13_FEB_88
Mitich        13_FEB_88
Lao           13_FEB_88
Abovian    14_MAR_90
Wakhib     12_JUL_90
Yaman      12_JUL_90
Kundak     12_JUL_90
Bursav       12_JUL_90

How can I get an output, that shows groups of employees with the same hiredates only? I don't need employees with unique hiredates. And I need to use hiredates as names of columns as shown below:

10_AUG_82        13_FEB_88        12_JUL_90
----------------        -----------------        -----------------
Smith                    Martens                Wakhib
Beaver                  Mitich                     Yaman
                                                               Kundak
                                                              Bursav

Thanks in advance. Received on Sun Mar 17 2002 - 02:48:23 CST