mongodb分組查詢(xún) oracle多字段分組取每組求和?
oracle多字段分組取每組求和?選擇T.*,sum(統(tǒng)計(jì)字段名)over(按分組字段1劃分),sum(統(tǒng)計(jì)字段名)over(按分組字段2劃分),sum(統(tǒng)計(jì)字段名)over(按分組字段3劃分),。。
oracle多字段分組取每組求和?
選擇T.*,sum(統(tǒng)計(jì)字段名)over(按分組字段1劃分),sum(統(tǒng)計(jì)字段名)over(按分組字段2劃分),sum(統(tǒng)計(jì)字段名)over(按分組字段3劃分),。。。和(統(tǒng)計(jì)字段名)在(分組字段n)上