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 ;
上一篇v4系列處理器有哪些特性
下一篇未轉變者水上飛機怎么開
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 ;