有一张表table,如图,请写sql语句删除重复信息
查询结果如图
select * from Table_1 where ID not in ( select a.id from Table_1 a inner join Table_1 b on a.age=b.age and a.id>b.id)