分享一个大神的人工智能教程。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到人工智能的队伍中来！点击浏览教程
-- 查找表中多余的重复记录，重复记录是根据单个字段来判断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)
-- 查找表中多余的重复记录（多个字段）select * from (select *, concat(`loan_case_id` , loan_term_id, task_stat
