SQL语句
delete from s_tableName where id in (select id from (select id from s_tableName where your_column in
(select your_column from s_tableName group by your_column having count(your_column)>1) and id not in
(select max(id) from s_tableName group by your_column having count(your_column)>1)) as tmpresult)