数据库中对于相同信息的删除处理

如何删除学生表中名字相同且年龄最大的学生信息

表 ：student
学生信息：name，age

delete from student
where id in
(select max(age) from student group by name having count(name)>1)

删除学生表中名字相同且只保留年龄最大的学生信息

delete from student
where id not in
(select max(age) from student group by name having count(name)>1)

查找表中多个字段相同的学生信息

select * from student a
where (a.name,a.age) in 
(select name,age from student group by name,age having count(*)>1)

删除表中多个字段相同的学生信息保留id最小的信息

delete from student a
where (a.name,a.age) in 
(select name,age from student group by name,age having count(*)>1)
and 
where id not in
(select min(id) from student group by name,age having count(*)>1)