Mysql学习总结（71）——MySQL 重复记录查询与删除总结

分享一个大神的人工智能教程。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到人工智能的队伍中来！点击浏览教程

-- 查找表中多余的重复记录，重复记录是根据单个字段来判断

select * from loan_collection_task where loan_case_id in (select loan_case_id from loan_collection_task group by loan_case_id having count(loan_case_id) >1)

-- 删除重复记录，只保留id字段值最大的记录

delete from loan_collection_task where loan_case_id not in (select maxid from (select max(id) as maxid from loan_collection_task group by loan_case_id) b)<