select count(*) from viewpoassets where leid in(1,2) --2747 select * from viewpoassets where leid in(1,2) --1667 不可能在session中间查,数据库重起了还是这样,对了,是在pl/sql developer中查询的
离谱了:select count(*) from ( select * from viewpoassets )a --6400
select count(*) from ( select * from viewpoassets where leid in(1,2) )a --1667
证明:select * from viewpoassets where leid in(1,2) --1667 select distinct * from viewpoassets where leid in(1,2) --1667 select count(*) from viewpoassets where leid in(1,2) --2747
在java中访问select * from viewpoassets where leid in(1,2) --2747
select count(*)
from (
select * from viewtassets
)a看看是不是和select count(*) from viewtassets 一样。
很有可能是2个之间插入了数据操作!!!!
看看PL/SQL里的那个commit按钮有没有灰掉啊!!!
select * from viewpoassets where leid in(1,2) --1667
不可能在session中间查,数据库重起了还是这样,对了,是在pl/sql developer中查询的
from (
select * from viewpoassets
)a --6400
from (
select * from viewpoassets where leid in(1,2)
)a --1667
select distinct * from viewpoassets where leid in(1,2) --1667
select count(*) from viewpoassets where leid in(1,2) --2747
PurchaseApp LEFT OUTER JOIN viewLocation ON
(PurchaseApp.LEID = viewLocation.LEID AND PurchaseApp.Location = viewLocation.Lcode)
显示出来PurchaseApp.LEID , viewLocation.LEID不等,有没有人遇到过这个问题?