Oracle SQL

[ashok rajagopal]

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 ?

[technobard]

create table t2
as
select a, b, c, sum(d) e from t1
group by a, b, c;