比如：统计表aa中ywlx列在某年某月每种类型各有多少? select year(aa_ywrq) as years, month(aa_ywrq) as months ,aa_ywlx,count(aa_ywlx) as number from aa group by year(aa_ywrq), month(aa_ywrq),aa_ywlx 表中数据： 查询后的结果：
比如：统计表aa中ywlx列在某年某月每种类型各有多少?
select
year(aa_ywrq) as years,
month(aa_ywrq) as months ,aa_ywlx,count(aa_ywlx) as number
from aa
group by year(aa_ywrq),
month(aa_ywrq),aa_ywlx
表中数据：
查询后的结果：