Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Removing repeating columns in query?

Removing repeating columns in query?

From: Pascal Byrne <byrne_at_icada.com>
Date: Tue, 22 Jan 2002 18:42:51 +0100
Message-ID: <3C4DA49B.5AE9D7E@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 - 11:42:51 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US