oracle 添加小计，合计

大神求助

举例说明：select t_year,t_month, sum(quantity) qty from test_group_table group byrollup(t_year,t_month)

 (select name, x, y, z, (x + y+ z) as 小计 from 表)
union
(select "合计"as name, sum(x) as x, sum(y) as y, sum(z) as z, (sum(x) + sum(y)+ sum(z)) as 小计 from 表)

楼主指的合计是指的以列计算还是行呢？哪些列和行？

增加一个伪列不就可以了