使用OracleDataAdapter填充数据和oracle实际的查询数据不一致
使用OracleDataAdapter填充如下SQL语句生成的数据到DataSet,DataSet的table[0].rows显示8条但实际在pl/sql developer查询出来为5条记录。select SYSID,
SENDID... from T_SMS_SEND
where SYSID in (7752, 7751, 7750, 7749, 7747)
and SENDER in
(Select USERID
from SYS_MEMBER
where ORGID in (select ORGID
from sys_orgnization
start with orgid = 357
connect by prior orgid = parentid))
加入distinct限定语句后 OracleDataAdapter 则正常显示了5条记录。
select distinct SYSID,
SENDID... from T_SMS_SEND
where SYSID in (7752, 7751, 7750, 7749, 7747)
and SENDER in
(Select USERID
from SYS_MEMBER
where ORGID in (select ORGID
from sys_orgnization
start with orgid = 357
connect by prior orgid = parentid))
猜想应该是.net的问题,但不知道什么原因?
--------------------编程问答-------------------- DISTINCT 用于返回唯一不同的值。 --------------------编程问答-------------------- 求解中
补充:.NET技术 , .NET Framework