Home >Database >Mysql Tutorial >SqlServer统计表中某年某月某个值有多少?

SqlServer统计表中某年某月某个值有多少?

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 14:54:011125browse

比如:统计表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

  表中数据:

SqlServer统计表中某年某月某个值有多少?   三联

  查询后的结果:

SqlServer统计表中某年某月某个值有多少?

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn