1.删除重复的记录,保留一条记录! delete a from table_1 a where [序号] > (select min([序号]) from table_1 b where a.[列名]=b.[列名])