摘要: 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 ... 阅读全文
posted @ 2013-01-12 16:57 byronming 阅读(220) 评论(0) 推荐(0) 编辑