sql 某字段各种值按月份统计
来源:互联网 发布:sql server 基础语法 编辑:程序博客网 时间:2024/05/16 17:35
DECLARE @Year int
SET @Year = 2013
SELECT m AS [Date], sum(CASE WHEN datepart(month, x_time) = m AND c.x_neixing = '建议信件' THEN 1 ELSE 0 END) AS [Count1],
sum(CASE WHEN datepart(month, x_time) = m AND c.x_neixing = '咨询信件' THEN 1 ELSE 0 END) AS [Count2], sum(CASE WHEN datepart(month, x_time)
= m AND c.x_neixing = '投诉信件' THEN 1 ELSE 0 END) AS [Count3]
FROM x_table c,
(SELECT 1 m
UNION ALL
SELECT 2
UNION ALL
SELECT 3
UNION ALL
SELECT 4
UNION ALL
SELECT 5
UNION ALL
SELECT 6
UNION ALL
SELECT 7
UNION ALL
SELECT 8
UNION ALL
SELECT 9
UNION ALL
SELECT 10
UNION ALL
SELECT 11
UNION ALL
SELECT 12) aa
WHERE @Year = year(x_time)
GROUP BY m
SET @Year = 2013
SELECT m AS [Date], sum(CASE WHEN datepart(month, x_time) = m AND c.x_neixing = '建议信件' THEN 1 ELSE 0 END) AS [Count1],
sum(CASE WHEN datepart(month, x_time) = m AND c.x_neixing = '咨询信件' THEN 1 ELSE 0 END) AS [Count2], sum(CASE WHEN datepart(month, x_time)
= m AND c.x_neixing = '投诉信件' THEN 1 ELSE 0 END) AS [Count3]
FROM x_table c,
(SELECT 1 m
UNION ALL
SELECT 2
UNION ALL
SELECT 3
UNION ALL
SELECT 4
UNION ALL
SELECT 5
UNION ALL
SELECT 6
UNION ALL
SELECT 7
UNION ALL
SELECT 8
UNION ALL
SELECT 9
UNION ALL
SELECT 10
UNION ALL
SELECT 11
UNION ALL
SELECT 12) aa
WHERE @Year = year(x_time)
GROUP BY m
阅读全文
0 0
- sql 某字段各种值按月份统计
- sql 按月份统计汇总排序
- SQL统计查询(按月份)
- SQL 语句按月份统计查询
- 按月份统计
- sql T_sql 通用的动态按月份统计输出
- SQL 按月份查询报表
- SQL按月统计
- sql查询单个项目的全年总和,按月份统计怎么实现?
- sql语句按月份进行汇总分组
- 按月份统计某一个机构的某列出现的次数
- 按月统计的sql语句
- (原) mysql 按月份统计查询数据
- sql 数据库中按月份的组查询
- Sql Server 考勤 按考勤号码按月份 分组汇总
- sql日期按月份和年份分组查询
- 实现按月消费统计的SQL语句
- SQL 按月统计(两种方式)
- 码云平台和git的使用帮助
- (24)单例设计模式两种写法:饿汉式和懒汉式
- HDU.1874 畅通工程续 (dijkstra)
- "应用程序无法正常启动(0xc000007b)。请单击 确定 关闭应用程序。"解决方法
- H5/JS入门
- sql 某字段各种值按月份统计
- OUTLINE转换为SPM
- python输入输出
- java编写多线程
- 外观模式C++实现
- 12_ARM汇编自学笔记指令系统之加载存储指令
- C++新课与C复习
- 【ML--02】第二课 线性回归
- Android-手机QQ浏览器耗电测试工具及方法介绍