example:
sql="delete from [types] where t_name in (select t_name from [types] group by t_name having count(t_name) > 1)and id not in (select min(id) from [types] group by t_name having count(t_name )>1)"
作用:删除types表中t_name字段相同的记录
那位能提供更简洁一点的语句
mail:cudng@163.com