SELECT '案件数量:' AS 所属部门,
CASE WHEN 承办部门 = '稽查一所' THEN CAST(COUNT(*) AS INT)
ELSE '' END AS 稽查一所,
CASE WHEN 承办部门 = '稽查三所' THEN CAST(COUNT(*) AS INT)
ELSE '' END AS 稽查三所
FROM 案件信息表
GROUP BY 承办部门结果为:所属部门 稽查一所 稽查三所
案件数量 0 1
案件数量 13 0
如何合并案件数量的两行啊?
CASE WHEN 承办部门 = '稽查一所' THEN CAST(COUNT(*) AS INT)
ELSE '' END AS 稽查一所,
CASE WHEN 承办部门 = '稽查三所' THEN CAST(COUNT(*) AS INT)
ELSE '' END AS 稽查三所
FROM 案件信息表
GROUP BY 承办部门结果为:所属部门 稽查一所 稽查三所
案件数量 0 1
案件数量 13 0
如何合并案件数量的两行啊?
SELECT '案件数量:' AS 所属部门,
SUM(CASE WHEN 承办部门 = '稽查一所' THEN CAST(COUNT(*) AS INT)
ELSE '' END) AS 稽查一所,
SUM(CASE WHEN 承办部门 = '稽查三所' THEN CAST(COUNT(*) AS INT)
ELSE '' END) AS 稽查三所
FROM 案件信息表
GROUP BY 承办部门
SUM(CASE WHEN 承办部门 = '稽查一所' THEN CAST(COUNT(*) AS INT)
ELSE 0 END) AS 稽查一所,
SUM(CASE WHEN 承办部门 = '稽查三所' THEN CAST(COUNT(*) AS INT)
ELSE 0 END )AS 稽查三所
FROM 案件信息表
GROUP BY 承办部门
SUM(CASE WHEN 承办部门 = '稽查一所' THEN CAST(COUNT(*) AS INT)
ELSE 0 END) AS 稽查一所,
SUM(CASE WHEN 承办部门 = '稽查三所' THEN CAST(COUNT(*) AS INT)
ELSE 0 END )AS 稽查三所
FROM 案件信息表
GROUP BY 承办部门这样试试?还有提示什么错误呀?
SUM(CASE WHEN 承办部门 = '稽查一所' THEN CAST(COUNT(*) AS INT)
ELSE '' END) AS 稽查一所,
SUM(CASE WHEN 承办部门 = '稽查三所' THEN CAST(COUNT(*) AS INT)
ELSE '' END) AS 稽查三所
FROM 案件信息表
GROUP BY 所属部门
SELECT 所属部门,SUM(稽查一所)稽查一所,SUM(稽查三所)稽查三所 FROM
(SELECT 案件数量 AS 所属部门,
CASE WHEN 承办部门 = '稽查一所' THEN CAST(COUNT(*) AS INT)
ELSE 0 END AS 稽查一所,
CASE WHEN 承办部门 = '稽查三所' THEN CAST(COUNT(*) AS INT)
ELSE 0 END AS 稽查三所
FROM 案件信息表
GROUP BY 承办部门)AS T
GROUP BY 所属部门
列名 列标题!
列标题=列名!
SUM(CASE WHEN 承办部门 = '稽查一所' THEN 1 ELSE 0 END) AS 稽查一所,
SUM(CASE WHEN 承办部门 = '稽查三所' THEN 1 ELSE 0 END) AS 稽查三所
FROM 案件信息表
GROUP BY 所属部门
(SELECT 案件数量 AS 所属部门,
CASE WHEN 承办部门 = '稽查一所' THEN CAST(COUNT(*) AS INT)
ELSE 0 END AS 稽查一所,
CASE WHEN 承办部门 = '稽查三所' THEN CAST(COUNT(*) AS INT)
ELSE 0 END AS 稽查三所
FROM 案件信息表
GROUP BY 承办部门)AS T
GROUP BY 所属部门