select sum(charge)
from (SELECT SERV_ID SERV_ID,
'0551' || a.acc_nbr acc_nbr,
acct_item_type_code,
nvl(DISCT_FLAG, -1) DISCT_FLAG,
SUM(NVL(charge, 0)) charge,
SUM(NVL(billing_duration, 0)) duration,
SUM(NVL(calls, 0)) calls,
SUM(NVL(duration, 0)) / 60 counts
FROM temp_serv_acct_item_2_551 a
WHERE month_id = 200908
GROUP BY SERV_ID, acc_nbr, acct_item_type_code, nvl(DISCT_FLAG, -1));SUM(CHARGE)
-----------
107900535.7select sum(charge) FROM temp_serv_acct_item WHERE month_id = 200908 ;
SUM(CHARGE)
-----------
107900443charge: number(12,2)两个统计值不一样。精度问题?
from (SELECT SERV_ID SERV_ID,
'0551' || a.acc_nbr acc_nbr,
acct_item_type_code,
nvl(DISCT_FLAG, -1) DISCT_FLAG,
SUM(NVL(charge, 0)) charge,
SUM(NVL(billing_duration, 0)) duration,
SUM(NVL(calls, 0)) calls,
SUM(NVL(duration, 0)) / 60 counts
FROM temp_serv_acct_item_2_551 a
WHERE month_id = 200908
GROUP BY SERV_ID, acc_nbr, acct_item_type_code, nvl(DISCT_FLAG, -1));SUM(CHARGE)
-----------
107900535.7select sum(charge) FROM temp_serv_acct_item WHERE month_id = 200908 ;
SUM(CHARGE)
-----------
107900443charge: number(12,2)两个统计值不一样。精度问题?
解决方案 »
- wampmysql cmd 中文乱码
- buffer hit 太低!!!!!!!!!!
- 卸载数据库
- 修改机器名使AGENT服务起来了,D:\oracle\ora90\network\ADMIN下面的二个文件tnsnames.ora,listener.ora
- 如何将用Oracle8i创建的数据库从一台机器转移到另一台机器上,详细步骤是什么?谢!
- 关于Oracle Develop6i的DEBUG问题
- 我在oracle官方网站下载的personal for 2000,一共有三个文件.zip,接下来我的具体步骤是什么?为什么点击setup不行:(
- 我用oracle security manager新建了一个用户,但不能登陆,why?
- 这样的灵活性可以实现吗? 欢迎各圈内的朋友进来讨论讨论!!!
- 如何优化sql语句
- 江湖救急!!!!!!
- 关于ORACLE的命令对象执行编译(Prepare)方法后cursor无法释放的问题
FROM temp_serv_acct_item_2_551 a FROM temp_serv_acct_item