表名:t_student
delete from t_student where id not in
(select min(s.id) from (select * from t_student) s group by s.name,s.age);
-- 找到分组中id最小的数据,其他的数据删除掉
表名:t_student
delete from t_student where id not in
(select min(s.id) from (select * from t_student) s group by s.name,s.age);
-- 找到分组中id最小的数据,其他的数据删除掉