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