delete from t_table where id not in ( select min(id) from t_table group by c_column)and id<>'123' 删除重复出现的数据,重复数据保留id最小的那个.