Home >Database >Mysql Tutorial >SqlServer统计表中某年某月某个值有多少？
SqlServer统计表中某年某月某个值有多少？
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 14:54:011133browse
比如：统计表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
表中数据：
查询后的结果：
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
Previous article：远程连接redis并给redis加锁Next article：PostgreSQL数据库用户密码的加密方式