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

转载于:https://www.cnblogs.com/wuyuwuyueping/p/9401127.html