摘要： student_score表如下： 表中张三的单元闯关成绩有2次，只保留最大值，其他删除，sql语句如下： delete from student_score where id not in ( select a.nid from (select id as nid,name,max(score) 阅读全文