Re: Removing repeating columns in query?

From: Tom Dyess <tdyess_at_dyessindustries.com>
Date: Tue, 22 Jan 2002 18:04:23 GMT
Message-ID: <HQh38.70420$_w.11911780@typhoon.tampabay.rr.com>

In sqlplus do this

SQL> break on division
SQL> select division, manager, project from tablename orderby division, manager

"Pascal Byrne" <byrne_at_icada.com> wrote in message news:3C4DA49B.5AE9D7E_at_icada.com...
> 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
>
>
Received on Tue Jan 22 2002 - 12:04:23 CST