k1 k2 k3 k4 k5
1 1 0 0 0
1 1 1 1 1
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
3 3 3 3 3
2 2 2 2 3
3 2 2 2 3
3 2 2 2 2想统计出这此记里中有多少个1多少个2多少个3望高手赐教
1 1 0 0 0
1 1 1 1 1
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
3 3 3 3 3
2 2 2 2 3
3 2 2 2 3
3 2 2 2 2想统计出这此记里中有多少个1多少个2多少个3望高手赐教
解决方案 »
- 最近在看jquery,谁那里有比较好的jquery的资料啊
- 问个正则的问题
- [散分200][分享]郁闷大发了,有关BindingSource和IList<自定义>类型的绑定问题
- WPF 联动
- 请教关于datagrid的小问题,请多指教!!!
- 请问WinForm的DataGrid能不能锁定几个字段,不会随着横向滚动条的移动而消失,多谢
- 寻求.NET下的整站系统,C#编写,界面美观大方,后台使用SQL SERVER数据库,哪位能提供下载地址,或给出相关线索,均有分!!谢谢!!
- 请建议买一本好书
- 一台机器的文件拷到另外一台机器用程序怎么解决?
- 为什么调用错误(c# SqlServer)
- 纠结问题
- 通过ASPxPivotGrid查询出来的数据自动加了¥0.00,请问如何取掉那个¥
Select Sum((Case K1 When 1 Then 1 Else 0 End) + (Case K2 When 1 Then 1 Else 0 End) + (Case K3 When 1 Then 1 Else 0 End) + (Case K4 When 1 Then 1 Else 0 End) + (Case K5 When 1 Then 1 Else 0 End)) From ...
时间来不及试了,你自己调试吧,其它差不多。
from (
select K1 as K,count(*) as cnt from table group by K1
union all select K2,count(*) from table group by K2
union all select K3,count(*) from table group by K3
union all select K4,count(*) from table group by K4
union all select K5,count(*) from table group by K5
)T
group by K
这么写一次就全统计出来了,包括0...
declare @table table (k1 int,k2 int,k3 int,k4 int,k5 int)
insert into @table
select 1,1,0,0,0 union all
select 1,1,1,1,1 union all
select 0,0,0,0,0 union all
select 0,0,0,0,0 union all
select 0,0,0,0,0 union all
select 3,3,3,3,3 union all
select 2,2,2,2,3 union all
select 3,2,2,2,3 union all
select 3,2,2,2,2select k1,count(*) as 个数 from
(select k1 from @table union all
select k2 from @table union all
select k3 from @table union all
select k4 from @table union all
select k5 from @table
) aa group by k1 having(k1<>0)/*
k1 个数
----------- -----------
1 7
2 11
3 9
*/
list.Where(p => p == 1).Count();//1的个数
list.Where(p => p == 2).Count();2的个数
list.Where(p => p == 3).Count();3的个数
SELECT SUM(NUM1) T1, SUM(NUM2) T2, SUM(NUM3) T3
FROM (SELECT LEN(STRS) - LEN(REPLACE(STRS, '1', '')) AS NUM1,
LEN(STRS) - LEN(REPLACE(STRS, '2', '')) AS NUM2,
LEN(STRS) - LEN(REPLACE(STRS, '3', '')) AS NUM3
FROM (SELECT REPLACE(STR(K1) + STR(K2) + STR(K3) + STR(K4) +
STR(K5),
' ',
'') AS STRS
FROM TESTSUM) TB1) TB