[每日一题]OCP1z0-047 :2013-08-15描述GROUPIN函数(二)
.
SQL> insert into gyj_test values(3,'C');
1 row created.
SQL> commit;
Commit complete.
SQL> select id,name,sum(id) sumid,grouping(id),grouping(name) from gyj_test group by rollup(id,name);
ID NAME SUMID GROUPING(ID) GROUPING(NAME)
---------- ---------- ---------- ------------ --------------
1 A 3 0 0
1 3 0 1
2 B 4 0 0
2 4 0 1
3 C 3 0 0
3 3 0 1
10 1 1
7 rows selected.