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 sum(字段名) from tab_name group by col1,col2,col3
select sum(col1),sum(col2),sum(col3) from tab_name group by col1,col2,col3
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024