比如:统计表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
表中数据:
查询后的结果:
推荐访问:统计表 有多少 某年某月 sql Server统计表中某年某月某个值有多少? sqlserver查询一个月 sqlserver中lpad