SELECT A, B, C, D, sum(D) FROM T GROUP BY A,B,C,D GROUPING SETS ((A,B,C,D),(A,B,D))
等价于
SELECT A, B, C, D, sum(D) FROM T GROUP BY A,B,C,D
UNION ALL
SELECT A, B, D, sum(D) FROM T GROUP BY A,B,D
等价于
SELECT A, B, C, D, sum(D) FROM T GROUP BY A,B,C,D
UNION ALL
SELECT A, B, D, sum(D) FROM T GROUP BY A,B,D