Re: Group By question

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, OHReceived on Tue Aug 17 2004 - 02:00:34 CDT