sum(cast req_num as float) 用发
来源:互联网 发布:刺客信条枭雄 知乎 编辑:程序博客网 时间:2024/06/16 09:37
sum(cast req_num as float) 这个用法是不对的
正确的是:
select top 3 calling,sum(case when result=200 then 1 else 0 end)/convert(float,sum(req_num)) as req_num2 from WAP_BDR010317 group by calling
calling req_num2
-------------------------------- ---------------------------
8613711012367 0.700000
8618825042842 0.750000
8613415200578 0.818182
0 0
- sum(cast req_num as float) 用发
- Cast on a "float" sequence throws InvalidCastException
- .net下面的as与“cast”
- oracle union & cast & sum & group by
- print float as int 的分析
- EXC_BAD_ACCESS and char pointer to float pointer cast
- SELECT CAST(10.6496 AS int) 的结果为?
- Effective C#读书笔记(3)as、is、cast类型转换
- select id,haha+'('+CAST(id as VARCHAR(20))+')' as hhaaa from db
- cast
- CAST
- cast
- Cast
- cast
- Cast
- CAST
- cast
- Struct is the same as int and float
- AAM(Active Appearance Model)算法介绍
- GDB调试问题No source file named file.c. Make breakpoint pending on future shared library load? (y or [n]
- Object.prototype.toString.call() 进行类型判断
- Java Static静态关键字理解
- win下oracle数据库的卸载
- sum(cast req_num as float) 用发
- gradle -version ERROR:JAVA_HOME is set to an invalid directory
- window下jconsole监控weblogic及远程不能访问的问题
- cocos2d-x中讲解TileMap地图编辑器的高级用法(对象层部分)
- openCV
- iOS GCD详解2
- instancetype 与 id for Objective-C
- iOS 主要的开源库
- VS代码清理脚本