Group By question

From: Dennis Hancy <dennishancy_at_eaton.com>
Date: 16 Aug 2004 13:58:17 -0700
Message-ID: <248587ca.0408161258.40a492cc@posting.google.com>

I have a table with this structure:

SSN varchar2
NAME varchar2
DEPT number

I need to produce a report that looks like this:

Dept         Name
0001         Edmund
             Miranda
             Zachary
0002         Stuart
             Mary
             Erica
             Kendall
             Adam
             Jamie
0003         Maria
             Ryan

In other words, I don't want to repeat the the department number. I only want to see it on the first line.

How do I accomplish this with SQL?

Thanks.

Dennis Hancy
Eaton Corporation
Cleveland, OH Received on Mon Aug 16 2004 - 15:58:17 CDT