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

posted @ 2018-08-01 14:37  wuyueping  阅读(65)  评论(0编辑  收藏  举报