现在我要对一个表进行数据汇总查询,如:
select ZLLBDM,count(ZLLB) num from AJJML_ZB group by ZLLBDM,
得出结果为:
"ZLLBDM" "NUM"
"10" "6"
"11" "138"
"12" "190"
"13" "70"
"14" "143"
"15" "9"
"16" "25"
"19" "14"
"20" "5"
"21" "2"
"22" "2"
"23" "5"
"29" "8"
"30" "3545"
"40" "46"
"41" "355"
"42" "266"
"43" "122"
"44" "4"
"50" "61"
"51" "552"
"52" "77"
"53" "8"
"54" "65"
"60" "348"
"70" "42"
"90" "151"怎么样根据首字母进行分类汇总统计?