用grouping即可，示例如下：

select job,
       deptno,
       grouping(job, deptno),
       sum(sal)
from   emp
group by rollup(job, deptno)
order by job,deptno;