不知道是不是从哪个贴拷的!SELECT
HEAT_CODE ,
sum( CASE WHEN CP2_SHIEF_DIVISION = '甲' THEN 1 ELSE 0 END ) AS A,
sum( CASE WHEN CP2_SHIEF_DIVISION = '乙' THEN 1 ELSE 0 END ) AS B,
sum( CASE WHEN CP2_SHIEF_DIVISION = '丙' THEN 1 ELSE 0 END ) AS C,
sum( CASE WHEN CP2_SHIEF_DIVISION = '丁' THEN 1 ELSE 0 END ) AS D
FROM MANAGE_CP2
WHERE HEAT_CODE IN ( SELECT DISTINCT HEAT_CODE
FROM QualityMovingCard
WHERE Moving_Bundle_time_to BETWEEN @DateFrom AND @DateTo)
GROUP BY HEAT_CODE
ORDER BY HEAT_CODE
HEAT_CODE ,
sum( CASE WHEN CP2_SHIEF_DIVISION = '甲' THEN 1 ELSE 0 END ) AS A,
sum( CASE WHEN CP2_SHIEF_DIVISION = '乙' THEN 1 ELSE 0 END ) AS B,
sum( CASE WHEN CP2_SHIEF_DIVISION = '丙' THEN 1 ELSE 0 END ) AS C,
sum( CASE WHEN CP2_SHIEF_DIVISION = '丁' THEN 1 ELSE 0 END ) AS D
FROM MANAGE_CP2
WHERE HEAT_CODE IN ( SELECT DISTINCT HEAT_CODE
FROM QualityMovingCard
WHERE Moving_Bundle_time_to BETWEEN @DateFrom AND @DateTo)
GROUP BY HEAT_CODE
ORDER BY HEAT_CODE
解决方案 »
- SQL如何根据分隔符一列转多列
- 报表数据量大 缓存机制
- 看到一很好的SQL代码
- 我的客户有一些访问不到我的SQL sever服务器,大部分客户正常
- sqlserver2005的iso文件如何安装呀
- 关于功能菜单和权限选择的问题,这个SQL应该怎么写?谢谢。
- 求救一简单问题,编写存储过程
- 求数据库系统工程考题详解
- 各位高手请帮个忙!!!!!!
- 通过宽带(ADSL)用vb连接远程sqlserver,出现[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或访问被拒绝错误!
- 怎样知道一个调度执行失败或没有执行???(MSSQL7)上火呀~~~
- 如何在mssqlserver里面判断一个字符串变量是同一天
改成:
SUM( CASE WHEN CP2_SHIEF_DIVISION = '甲' THEN 1 ELSE 0 END ) AS A,
因为:
在非NULL值情况下:
count(0),count(*),count(field)是一样的。