如下图怎么实现啊?数据表ID_C ID_D ID_K ID_N ID_O ID_P TS_Unit
1 1 1 2 3 1 a
2 2 1 1 2 4 b
1 3 2 1 1 2 a
我的QQ:6380199
1 1 1 2 3 1 a
2 2 1 1 2 4 b
1 3 2 1 1 2 a
我的QQ:6380199
解决方案 »
- aspx页面应用母版页后怎么用JS找服务器控件?
- 如何抓取ajax数据 急~~~
- private int? _ProUID;
- 在Asp.Net中如何从数据库中循环读取图片
- 关于主从表绑定问题...请孟子老大回话(急...)
- VS.NET中匹配所有<script>...</script>的正则表达式怎样写?
- ***不是吧,这样也行?这里好象是不能倒分的***
- asp.net程序编译成功后运行提示BC31007错误
- 两个问题
- 如何给DataList里的EditItemTempLate下的Label控件赋值?
- aspx文件上的中文文字我想用XML中的元素替代,应该怎么作啊?兄弟们给个思路,谢谢
- 追求最简洁实现存储过程的方法
要是求每个的和;
select sum(ID_C) as c,sum(ID_D) as d,sum(ID_K) as k,sum(ID_N) as n,sum(ID_O) as o,sum(ID_P) as p,sum(TS_Unit) as ts from tableName
信访投诉 各级检查 以车谋私 以票谋私 勒卡索要 两乱 粗暴待客 违规经营 违规贩运 其他 客运 货运 公安 车辆 两经 其他 严重以上 一般事件 不良反映 上级批评 上级A批评 统计件数 不计件数 开除 留用察看 解除合同 撤职降职 记过警告 经济处罚 其他 属实 不属实
1 单位A 0 0 0
2 单位B 0
图搞不出来,没有传附件的
http://community.csdn.net/Expert/topic/4755/4755320.xml?temp=.4605371select id,name,sum(HO) as HO,sum(GO) as GO,sum(CO) as CO from(
select id,name,b as HO,0 as GO,0 as CO from table where c='HO'
union all
select id,name,0 as HO,B as GO,0 as CO from table where c='GO'
union all
select id,name,0 as HO,0 as GO,B as CO from table where c='CO'
) t
group by id,name
是这个意思吧?
select sum(ID_C) as c,sum(ID_D) as d,sum(ID_K) as k,sum(ID_N) as n,sum(ID_O) as o,sum(ID_P) as p,TS_Unit into from tableName group by TS_Unit;
TS_Unit ID 1 2a ID_C 2 0
b ID_C 0 1
.
.
.