sql去重

delete 表名 where id notin(SELECTMAX(id) AS id FROM 表 GROUPBY 字段名) --- 删除重复行
select*from 表名 where id in( SELECTMAX(id) AS id FROM 表 GROUPBY 字段名) --重复行只查询一条