删除除了id号不同,其它都相同的学生信息
这样可能会报错, 因为删除数据会导致统计结果不一致. 所以引用一张虚表就好.
delete from tablename where id not in
(select min(id) from tablename group by 学号,姓名,分数)
要建表过渡一下, 不然报错
delete from tablename where id not in
(select id from (select min(id) id from tablename group by 学号,姓名,分数 ) tem)
delete from tablename where id in
(select min(id) id from tablename group by 学号,姓名,分数 having id != min(id)
评论区