sql 去重

delete from table t1 where t1.id not in (select max(id) from table group by 列名,列名1,列名2)