Oracle中grouping,grouping_id,rollup,cube这些汇总/高级分组相关函数： GROUP BY ROLLUP(COL1,COL2) 相当于： GROUP BY COL1,COL2 UNION ALL GROUP BY COL1,NULL UNION ALL GROUP BY NULL,NULL GROUP BY CUBE(COL1,COL2) 相当于： GROUP BY COL1,COL2 UNION ALL GROUP BY COL1,NULL UNION ALL GROUP BY NULL,COL2 UNION ALL GROUP BY NULL,NULL GROUP BY GROUPING SETS(COL1,COL2) 相当于: GROUP BY COL1,NULL UNION ALL GROUP BY NULL,COL2