Sql同表去除重复

有一张表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)
原文地址:https://www.cnblogs.com/happygx/p/2586174.html