SQL 删除重复数据

delete from table where id not in (
select max(id) from table group by 字段
)