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 -> merging rows

merging rows

From: <vissuyk_at_yahoo.com>
Date: 19 Apr 2005 20:39:09 -0700
Message-ID: <1113968349.388413.31140@l41g2000cwc.googlegroups.com> 





Hi All,



What is the best way to merge some rows. Lets say I have three rows in
a table and I want to replace them three with one row.



Columns: A, B , C, D , E



If Columns A, B and C are equal for rows then I want to merge those
rows into one. I would use SUM on D and AVG on E.



Any suggestions are appreciated



Vissu
Received on Tue Apr 19 2005 - 22:39:09 CDT












Original text of this message













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