摘要：有一张表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) 阅读全文