oracle 多字段分组取每组求和

select t.* ,

sum(统计字段名) over(partition by 分组字段1),

sum(统计字段名) over(partition by 分组字段2),

sum(统计字段名) over(partition by 分组字段3),

......

sum(统计字段名) over(partition by 分组字段n)

from t

select xx1,xx2,yy,yy/sum(yy)over() zz

from(

select xx1,xx2,sum(xx3) as yy

from table_name

group by xx1,xx2

)

---