Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Group By question
SELECT CASE
WHEN row_number() OVER(PARTITION BY dept ORDER BY name) = 1 THEN ID ELSE NULL END dept, name FROM t ORDER BY dept,name
Jan
dennishancy_at_eaton.com (Dennis Hancy) wrote in message news:<248587ca.0408161258.40a492cc_at_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 Tue Aug 17 2004 - 02:00:34 CDT