SELECT Users,
(SELECT COUNT(B.TaskID) FROM Users Where A.Users=B.Users FROM Log AS B AND B.Status = Standar),
(SELECT COUNT(C.TaskID) FROM Users Where A.Users=C.Users FROM Log AS C AND C.Status = Execute),
(SELECT COUNT(D.TaskID) FROM Users Where A.Users=D.Users FROM Log AS D AND C.Status = Incomplete)
FROM Log AS A
是这样吗?
(SELECT COUNT(B.TaskID) FROM Users Where A.Users=B.Users FROM Log AS B AND B.Status = Standar),
(SELECT COUNT(C.TaskID) FROM Users Where A.Users=C.Users FROM Log AS C AND C.Status = Execute),
(SELECT COUNT(D.TaskID) FROM Users Where A.Users=D.Users FROM Log AS D AND C.Status = Incomplete)
FROM Log AS A
是这样吗?
解决方案 »
- 无法在当前安全上下文下访问数据库 "model"
- 请问如何跨域访问使用自定义实例名的SQLSERVER
- 建库时数据库数据文件选择根目录无法创建,而放到1个目录中就可以了呢
- 如何撤销sql数据库的备份恢复
- SQL存储过程问题
- 在sqlserver2000中如何减少日志文件的大小,不用语句,直接用功能键有吗
- 有人用过SQL Server6.5吗? 怎么建一个带有游标输出参数的存储过程啊
- 如何在SQL中声明一个数组变量以及相关SQL语句应该怎么写?
- 多线程怎么对数据库操作
- ms Sql中同一个表,如何将字段A的值赋给字段B(全部字段)??
- 连接池满的错误
- 同时从两对主从表取数据放到一个数据集中的SQL语句问题
sum(case when Status= 'Execute' then 1 end ) 正在完成,
sum(case when Status= 'Incomplete' then 1 end ) 还没有做
group by 用户名
select [users],
[status],
count(*) as 工作量
from [log]
group by [users],[status]
select [users]
,已经完成=sum(case status when 'Standar' then 1 else 0 end)
,正在完成=sum(case status when 'Execute' then 1 else 0 end)
,还没有做=sum(case status when 'Incomplete' then 1 else 0 end)
from [log]
group by [users]
sum(case when Status= 'Execute' then 1 end ) 正在完成,
sum(case when Status= 'Incomplete' then 1 end ) 还没有做
group by 用户名
select status,count(taskID) FROM log group by status.