delete 表名 where id notin(SELECTMAX(id) AS id FROM 表 GROUPBY 字段名) --- 删除重复行
select*from 表名 where id in( SELECTMAX(id) AS id FROM 表 GROUPBY 字段名) --重复行只查询一条
转载于:https://www.cnblogs.com/leonardleonard/archive/2013/03/22/2976296.html
delete 表名 where id notin(SELECTMAX(id) AS id FROM 表 GROUPBY 字段名) --- 删除重复行
select*from 表名 where id in( SELECTMAX(id) AS id FROM 表 GROUPBY 字段名) --重复行只查询一条
转载于:https://www.cnblogs.com/leonardleonard/archive/2013/03/22/2976296.html