比如:统计表aa中ywlx列在某年某月每种类型各有多少? ? 1 2 3 4 5 6 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列在某年某月每种类型各有多少? ? 1 2 3 4 5 6 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 表中数据: 查询后的结果: