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
