搜索结果带合计

Question

数据表AAAA Ba aab bbc ccc ddselect A,count(B) from AAA group A   结果：a 1b 1c 2现在我想把结果变成带个合计,也就是a 1b 1c 2   合计 4有没有用办法用SQL语句实现？

Answer 1

declare @t table(A varchar(20),B varchar(50))
insert @t
select 'a', 'aa'
union all
select 'b','bb'
union all
select 'c', 'cc'
union all
select 'c', 'dd'


select  case when grouping(A)=1 then '合计' else A end,count(1)
from @t
group by A with cube

Answer 2

union all select 'cont',Count(num) from table