Re: Removing repeating columns in query?

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 Tue Jan 22 2002 - 14:13:48 CST