摘要:
SQL> select a, b, sum(c), grouping(a), grouping(b), grouping(c) from test group by rollup(a, b, c);A B SUM(C) GROUPING(A) GROUPING(B) GROUPING(C)---------- ---------- ---------- ----------- ----------- -----------a aaa 10 0 0 0a aaa 20 0 0 0a aaa 30 0 0 ... 阅读全文