mysql去重，不用distinct和group by

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