现在我要对一个表进行数据汇总查询,如:
select ZLLBDM,count(ZLLB) num from AJJML_ZB group by ZLLBDM,
得出结果为:
"ZLLBDM" "NUM"
"10" "6"
"11" "138"
"12" "190"
"13" "70"
我想把所有的NUM再求一个总值,如下面的效果。不知道SQL语句怎么写"ZLLBDM" "NUM"
"10" "6"
"11" "138"
"12" "190"
"13" "70"
sum "404"
select ZLLBDM,count(ZLLB) num from AJJML_ZB group by ZLLBDM,
得出结果为:
"ZLLBDM" "NUM"
"10" "6"
"11" "138"
"12" "190"
"13" "70"
我想把所有的NUM再求一个总值,如下面的效果。不知道SQL语句怎么写"ZLLBDM" "NUM"
"10" "6"
"11" "138"
"12" "190"
"13" "70"
sum "404"
count(ZLLB) num
from AJJML_ZB
group by rollup(ZLLBDM)
union all
select '',sum(num) num from
(select ZLLBDM,count(ZLLB) num from AJJML_ZB group by ZLLBDM)
count(ZLLB) num
from AJJML_ZB
group by rollup(ZLLBDM)少了个