select a,count(*) as b from c group by a后怎样再得到总count(*)

[cd_dragon]

谢谢

[hdkkk]

select a,count(*) as b from c group by a
union
select 'total',count(*) as b from c
;

[black_dragon]

select to_char(a),count(*) as b from c group by a
union
select 'overall',count(*) b from c;

[jlandzpa]

niu

[developer2002]

试试这个吧：
select a,count(*) from c group by rollup(a)

[liujianleiwj]

两种方法:
1.group by rollup(a)
2.group by cube(a)
祝你好运

[wujinbao]

是不是应该这样？
select 'total',count(*) as b from c
union
select a,count(*) as b from c group by a

[cd_dragon]

这么好用的东西我都不知道，xx
rollup
cube
有什么区别亚