Re: Removing repeating columns in query?

From: Tom Dyess <tdyess_at_dyessindustries.com>
Date: Wed, 23 Jan 2002 13:37:59 GMT
Message-ID: <X0z38.422729$oj3.80017501@typhoon.tampabay.rr.com>

Svend,

Awesome, I didn't know you could do that. I was trying break on division, manager, but of course it didn't appreciate my mangled syntax. Thanks for the tip!

Tom
www.oraclepower.com

"Svend Jensen" <Master_at_OracleCare.Com> wrote in message news:3C4DC7FC.5010505_at_OracleCare.Com...
> Pascal Byrne wrote:
>
> > Hi all,
> > I need create a report ordered by a primary and secondary column that
> > only
> > displays each ordered column value once e.g.
> >
> > DIVISION MANAGER PROJECT
> > -------- ------- -------
> > Engineering John Doe WebMail
> > Editor Pro
> > RSM
> > Joe Soap Hyperhub
> > Accounts Bob Billings Ledger
> >
> >
> > How can I do this in plain SQL?
> >
> > Thanks,
> > pascal
> >
> >
>
> This can not be done from SQL, but SQL*Plus - then
> break on division skip 2 on manager skip 1.
> The skip(s) gives 2 linefeeds when division changes
> and one linefeed when manager. Fit to your needs.
> /Svend
>
>
Received on Wed Jan 23 2002 - 07:37:59 CST