orcale 执行下面
select ninnum from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum<3
得到的结果是 315000 74000
注意,我对字段加了一个sum如下
select sum(ninnum) from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum<3
得到的结果不是上面的两个字相加389000,而是一个错误的值:310000
请问这是为什么呢????
...全文
38412打赏收藏
Oracle sum求和问题
orcale 执行下面 select ninnum from ic_general_h a, ic_general_b b where a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum<3 得到的结果是 315000 74000 注意,我对字段加了一个sum如下 select sum(ninnum) from ic_general_h a, ic_general_b b where
elect sum(ninnum) from (select ninnum from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum <3 )
[Quote=引用楼主 jeenhuang 的回复:]
orcale 执行下面
select ninnum from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum <3
得到的结果是 315000 74000
注意,我对字段加了一个sum如下
select sum(ninnum) from (select ninnum from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum <3 )
[Quote=引用楼主 jeenhuang 的回复:]
orcale 执行下面
select ninnum from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum <3
得到的结果是 315000 74000
注意,我对字段加了一个sum如下
selectsum(ninnum) from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum <3
得到的结果不是上面的两个字相加389000,而是一个错误的值:310000
请问这是为什么呢????
[/Quote]
我想应该是rownum <3问题,而且你的两个表里面的有不规则数据吧
试下这个:
select sum(ninnum) from(
select ninnum from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U'
) where rownum < 3;
[Quote=引用 3 楼 sbaz 的回复:]
select ninnum from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum <3
select sum(ninnum) from (
select ninnum from ic_general_h a, ic_general_b b where
a.cgeneralhid =+b.cgeneralhid and cdispatcherid ='0001AA1000000000GY9U' and rownum <3
)