要求统计出每个PartCode的这七种ReasonCode的Num各自之和
解决方案 »
- 运行不了???帮忙修改一下!
- 一条查询语句 求助
- 求sql语句流水单号
- 小弟是一个大一学生 刚刚自己学习了数据库 遇到点小问题 希望广大朋友给点意见 ,谢谢
- 用sqlcmd登录,显示18456错误
- 请教哈哈继续
- 请问如何得到procedure的返回值?
- 十万火急
- 我安装的是英文版的sqlserver,现在想装上中文版的books online,但是好像不能覆盖安装(能吗?),我就装在其它目录,但⑸不知如何打开
- 如何在装过SQL Server6.5的机器上成功配置用于连接SQL Server2000的ODBC文件?在线等待,高分相送。
- transact-sql语句中的escape语句怎样写
- 会用log explorer的请帮忙,update 后的数据如何恢复
,[A NUM]=sum(case ReasonCode when 'A' then Num else 0 end)
,[B NUM]=sum(case ReasonCode when 'B' then Num else 0 end)
,[C NUM]=sum(case ReasonCode when 'C' then Num else 0 end)
,[D NUM]=sum(case ReasonCode when 'D' then Num else 0 end)
,[E NUM]=sum(case ReasonCode when 'E' then Num else 0 end)
,[F NUM]=sum(case ReasonCode when 'F' then Num else 0 end)
,[G NUM]=sum(case ReasonCode when 'G' then Num else 0 end)
from 表
group by PartCode
(select sum(num) from tabl where PartCode=tabl1.PartCode and ReasonCode='A') as [A NUM],
(select sum(num) from tabl where PartCode=tabl1.PartCode and ReasonCode='B') as [B NUM],
(select sum(num) from tabl where PartCode=tabl1.PartCode and ReasonCode='C') as [C NUM],
(select sum(num) from tabl where PartCode=tabl1.PartCode and ReasonCode='D') as [D NUM],
(select sum(num) from tabl where PartCode=tabl1.PartCode and ReasonCode='E') as [E NUM],
(select sum(num) from tabl where PartCode=tabl1.PartCode and ReasonCode='F') as [F NUM],
(select sum(num) from tabl where PartCode=tabl1.PartCode and ReasonCode='G') as [G NUM]
from tabl tabl1