MySQL删除重复数据保留第一条数据

DELETE t1 FROM yhx_credit_result t1
INNER JOIN yhx_credit_result t2
WHERE t1.id > t2.id AND t1.request_no = t2.request_no;

删除重复数据