oracle 中rollup函数,oracle分组函数之ROLLUP

1.初始化实验坏境

1)创建测试表group_test

sec@ora10g> create table group_test (group_id int, job varchar2(10), name varchar2(10), salary int);

Table created.

2)初始化数据

insert into group_test values (10,'Coding',    'Bruce',1000);

insert into group_test values (10,'Programmer','Clair',1000);

insert into group_test values (10,'Architect', 'Gideon',1000);

insert into group_test values (10,'Director',  'Hill',1000);

insert into group_test values (20,'Coding',    'Jason',2000);

insert into group_test values (20,'Programmer','Joey',2000);

insert into group_test values (20,'Architect', 'Martin',2000);

insert into group_test values (20,'Director',  'Michael',2000);

insert into group_test values (30,'Coding',    'Rebecca',3000);

insert into group_test values (30,'Programmer','Rex',3000);

insert into group_test values (30,'Architect', 'Richard',3000);

insert into group_test values (30,'Director',  'Sabrina',3000);

insert into group_test values (40,'Coding',    'Samuel',4000);

insert into group_test values (40,'Programmer','Susy',4000);

insert into group_test values (40,'Architect', 'Tina',4000);

insert into group_test values (40,'Director',  'Wendy',4000);

commit;

3)初始化之后的数据情况如下：

sec@ora10g> select * from group_test;

GROUP_ID JOB        NAME           SALARY

---------- ---------- ---------- ----------

10 Coding     Bruce            1000

10 Programmer Clair            1000

10 Architect  Gideon           1000