Oracle rollup进行分组汇总统计

3对group_id进行普通的roolup操作---按照小组进行分组，同时求总计
SECOOLER@ora11g> select group_id,sum(salary) from group_test group by rollup(group_id);

  GROUP_ID SUM(SALARY)
---------- -----------
        10        4000
        20        8000
        30       12000
        40       16000
                 40000