有表如下
name star Jan Feb march
A 1-X 1 -1 0
B 1-X 1 1 1
C 2-X -1 0 0统计按star分每列等于-1的数量
star Jan Feb march
1-X 0 1 0
2-X 1 0 0哪位大哥指点一下,多谢
name star Jan Feb march
A 1-X 1 -1 0
B 1-X 1 1 1
C 2-X -1 0 0统计按star分每列等于-1的数量
star Jan Feb march
1-X 0 1 0
2-X 1 0 0哪位大哥指点一下,多谢
解决方案 »
- 怪事,文本框的enter事件中 selectall()无效,加上一句 messagebox.show就起作用
- C#初学者求助在窗体里无法建立有返回值的方法
- 在WCF中,在客户端如何传List<System.Data.SqlClient.SqlParameter>至WCF服务中,谢谢 急
- WORD 2007 外接程序菜单,调试正常,正常执行就无效?哭
- C#,实现多语言的界面,想用资源文件实现,但一般资源文件的格式是什么?
- 关于dll返回字符串在C#下调用的问题
- c#子页面接收母板页的搜索结果
- 求一个已知图的拓扑排序算法
- Httphandler ~~~~~~~~~~~~~~求救 高手!
- 请教C#导出Access数据库,并加密.
- c# 服务器和客户端连续通讯问题
- 有没有专门的c#源代码 网站
(SELECT COUNT(*)
FROM Table1 A
WHERE A.Star = MainTable.star AND Jan = - 1) AS Jan,
(SELECT COUNT(*)
FROM Table1 B
WHERE B.Star = MainTable.star AND Feb = - 1) AS Feb,
(SELECT COUNT(*)
FROM Table1 C
WHERE C.Star = MainTable.star AND March = - 1) AS March
FROM TABLE1 MainTable
sum(case when Jan=-1 then 1 else 0 end ) as Jan,
sum(case when Feb=-1 then 1 else 0 end ) as Feb,
sum(case when march=-1 then 1 else 0 end ) as March
from T
group by start