select * from t_risk_log t where claim_no='0000626040'
根据claim_no和response_time去重,sql如下
select * from t_risk_log t ,(select claim_no,max(response_time) response_time from t_risk_log where claim_no='0000626040' group by claim_no ) m
where t.response_time=m.response_time and t.claim_no=m.claim_no