CUBE可以实现各个层级的分组统计。
建测试表 t1:
SELECT
alias
,department
,sum(val) as val
FROM
t1
GROUP BY CUBE(alias,department)
;
结果如下:
CUBE可以实现各个层级的分组统计。
建测试表 t1:
SELECT
alias
,department
,sum(val) as val
FROM
t1
GROUP BY CUBE(alias,department)
;
结果如下: