select * from (select * from
UT_MEMBERORGRELA t where not exists
(select 1 from UT_MEMBERORGRELA t1 where t1.Pkid=t.pkid and TRUNC(t1.Enterdate)>TRUNC(t.Enterdate)))
where mpkid='RTCS000000000109364'--------------------------------------------------------------------------------------
select * from UT_MEMBERORGRELA where mpkid='RTCS000000000109364'
这样查询有三条,为什么上面用not exists 查还是三条,没有筛选出时间最大的??
UT_MEMBERORGRELA t where not exists
(select 1 from UT_MEMBERORGRELA t1 where t1.Pkid=t.pkid and TRUNC(t1.Enterdate)>TRUNC(t.Enterdate)))
where mpkid='RTCS000000000109364'--------------------------------------------------------------------------------------
select * from UT_MEMBERORGRELA where mpkid='RTCS000000000109364'
这样查询有三条,为什么上面用not exists 查还是三条,没有筛选出时间最大的??
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货