Code Forums - View Single Post

ashok rajagopal · 03-29-2006, 07:07 PM

I have a table T1 with columns A,B,C,D. for each unique A-B-C combination, i have a number of values in D. I want to create a new table T2 with columns A,B,C,E where A,B,C make up a primary key ,and E is the sum of all D values corresponding to A,B,C .

How can i do it ?

03-29-2006, 07:07 PM	#1 (permalink)
ashok rajagopal Registered User Join Date: Sep 2005 Posts: 20	Oracle SQL I have a table T1 with columns A,B,C,D. for each unique A-B-C combination, i have a number of values in D. I want to create a new table T2 with columns A,B,C,E where A,B,C make up a primary key ,and E is the sum of all D values corresponding to A,B,C . How can i do it ?