我现在在做分类汇总统计,
例如:Select name,count(id) num from table1 group by name
结果为:
name num
aaaa 2
bbbb 3
cccc 7我想获取汇总结果的和,就是自动计算累加值,生成以下结果:
name num
aaaa 2
bbbb 3
cccc 7
sum 12不知道怎么写SQL语句?
例如:Select name,count(id) num from table1 group by name
结果为:
name num
aaaa 2
bbbb 3
cccc 7我想获取汇总结果的和,就是自动计算累加值,生成以下结果:
name num
aaaa 2
bbbb 3
cccc 7
sum 12不知道怎么写SQL语句?
from table1
group by CUBE(name)
ORDER BY NAME
union all
select 'sum',count(id) from table1
;
Select (case grouping(name) when 1 then 'sum' else name end) name, count(id) num
from table1 group by cube(name) order by num
select 1 id, 'a' name from dual union all
select 2 id, 'a' name from dual union all
select 3 id, 'b' name from dual union all
select 4 id, 'b' name from dual union all
select 5 id, 'b' name from dual union all
select 6 id, 'c' name from dual union all
select 7 id, 'c' name from dual union all
select 8 id, 'c' name from dual union all
select 9 id, 'c' name from dual union all
select 10 id, 'c' name from dual union all
select 11 id, 'c' name from dual union all
select 12 id, 'c' name from dual)
SELECT nvl(NAME, 'sum') NAME, COUNT(id) num FROM tt GROUP BY ROLLUP(NAME);
Select name,count(id) num
from table1
group by rollup(name)
order by name