select * from
( select tt.* ,rownum rn from
( select *
from prpcmain main
where main.PolicyNo = '301071824401000001389'
order by main.operatedate desc,
main.operatetime desc ) tt ) t
where rn = 1
Oracle
拼命敲
select * from
( select tt.* ,rownum rn from
( select *
from prpcmain main
where main.PolicyNo = '301071824401000001389'
order by main.operatedate desc,
main.operatetime desc ) tt ) t
where rn = 1